Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How would you retrieve the first five records

Re: How would you retrieve the first five records

From: Bert Scalzo <bscalzo01_at_7-11.com>
Date: Mon, 29 Mar 1999 12:46:37 -0600
Message-ID: <7dohnu$iau$1@news.ses.cio.eds.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US