Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How would you retrieve the first five records
In Oracle 8i (i.e. 8.1.5) you can do this easily via inline views:
select *
(select * from employee order by salary)
where rownum <= 5;
Received on Mon Mar 29 1999 - 12:46:37 CST