Eternius: Zweit aktuellster Eintrag anzeigen

Beitrag lesen

Hallo,

" The LIMIT clause can be used to constrain the number of rows returned by the SELECT  statement. LIMIT takes one or two numeric arguments, which must both be positive integer constants (including zero).

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):

mysql> SELECT * FROM table LIMIT 5,10;  # Retrieve rows 6-15

For compatibility with PostgreSQL, MySQL also supports the LIMIT row_count OFFSET offset syntax. "

Quelle

gruss

--
no strict;
no warnings;
Meine Signatur hat Urlaub.