Re: limit

Yes, it is possible.

select * from users where rownum < 11;

returns the first 10 rows and

select * from users where rownum < 21
minus
select * from users where rownum < 11;

returns the 10 next rows (20 first ones minus 10 first ones).

Francesc Guasch a écrit dans le message <358FF850.16AAACA6_at_etsetb.upc.es>...
|Can I do a select with a limit statement so :
|
|select * from users limit 10;
|
|so it only returns the first 10 in the query ?
|if so ... is there an easy way to return the next 10 items ?
|
|thanks
|--
|mailto:frankie@etsetb.upc.es http://www.etsetb.upc.es/~frankie
| ^-^.-----,
| o o _ ) Linux, Windows 95, and Windows NT
| Y (_, (__(Ssss (also known as the Good, the Bad, and the Ugly)
Received on Tue Jun 23 1998 - 14:16:50 CDT