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 === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
