am 22.02.2006, um 9:06:57 -0000 mailte padmanabha konkodi folgendes:
>
>
> hi all,
>
> my query return 100 rows but if i am intrested only from 40-60 rows then how to restrict.
>
> for example
>
> select * from students (returns 100 rows).but i am intrested only rows from 40 to 60.
select * from students limit 20 offset 40;
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net=== Schollglas Unternehmensgruppe ===