Re: begginer - select first X records

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 Sat Feb 03 2001 - 16:07:57 CST