Re: begginer - select first X records

Please check deja for similar requests, this may be the most asked question in this group:

There is no such thing as the FIRST x records in an Oracle database...as a relational database the storage order of records is indeterminate, so there is no way to 'designate' a FIRST ( or a LAST for that matter)...To retrieve a limited set of sorted data, try:
[ in 8.1 and above only, I believe]
Select * from (select * from files order by f_date desc) where rownum < 11;

"ONASSIS" <nfrank_at_interactive1.hr> wrote:

>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 Mon Feb 05 2001 - 10:35:49 CST