Einzelnen Beitrag anzeigen
Alt 15.04.2003, 08:37   #4
jonix
Veteran
 
Registriert seit: 03.08.2000
Alter: 47
Beiträge: 461


Standard

keine sortierung - die ersten 10 offsets aus der tabelle ;-)

http://www.mysql.com/doc/en/SELECT.html:
Zitat:
The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. The arguments must be integer constants. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1): To be compatible with PostgreSQL MySQL also supports the syntax: LIMIT # OFFSET #.
____________________________________
hampel.at
jonix ist offline   Mit Zitat antworten