Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to select a range of records by rownum?
select a.rn, a.user, a.email from
(select rownum rn, user, email from clients) a where a.rn between 40 and 100
Slava. Received on Wed Mar 26 1997 - 00:00:00 CST