Re: begginer - select first X records

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