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

Home -> Community -> Usenet -> c.d.o.tools -> Re: begginer - select first X records

Re: begginer - select first X records

From: wysza <awysza_at_yahoo.com>
Date: Sun, 04 Feb 2001 15:14:35 GMT
Message-ID: <vlef6.7150$5H.1150777@typhoon2.ba-dsg.net>

just a little mistake, it should be:
[...] WHERE ROWNUM <= X [...]

"Jan Elbæk" <jael_at_worldonline.dk> wrote in message news:og%e6.22439$fa3.1188581_at_news010.worldonline.dk...
> Hi,
>
> something like this will do the trick :-)
>
> select * from files WHERE ROWNUM = X order by f_date desc
>
> where X is the actual number of records you want as result of your
 query...
>
> Best regards...
>
> /Jan
>
> "ONASSIS" <nfrank_at_interactive1.hr> skrev i en meddelelse
> news:95gqiq$rap$1_at_sunce.iskon.hr...
> > If somebody can help me with this trivial task:
> > - How to select only first X records in Oracle? Something like
> >
> > select * from files order by f_date desc RECORDS(1, 10)
> >
> > Thanks in advance,
> > Damir (from Neven's account this time 8-)).
> >
> >
> >
> >
>
>
Received on Sun Feb 04 2001 - 09:14:35 CST

Original text of this message

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