am 21.04.2006, um 14:59:23 +1000 mailte kadil folgendes:
> Does anyone have an elegant way (sql) to query:
>
> select (various columns) from (several joined tables) where
> (resultset_row_numbers is between specified_first_row and
> specified_last_row)
LIMIT and OFFSET
select foo from bla oder by 1 limit 2 offset 3;
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===