Re: limit

On Tue, 23 Jun 1998 20:47:44 +0200, Francesc Guasch <frankie_at_etsetb.upc.es> wrote:

>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 ?

Use "rownum < xx" like:

Select *
from users
where rownum < 11

To equal rownum with a number doesn't work.

>if so ... is there an easy way to return the next 10 items ?

Only in PL/SQL with a cursor.

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---