Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to select a range of records by rownum?
> > "select rownum, user, email from clients where rownum >= 40" failed
>
> will never return any rows. Think about it, the first record returned
> will have rownum = 1 which is not greater than 40 so is discarded. The
> next record returned will still have rownum = 1 and again will be
> discarded and so on.
Wonderful. What's the solution?
Daniel A. Morgan Received on Tue Mar 25 1997 - 00:00:00 CST