Re: begginer - select first X records

Order by only runs on the results, it cannot be used in a subselect. (At least last I heard).

Damir Mazar wrote in message <95p9ub$6pp$1_at_sunce.iskon.hr>...
>Hm! it seems that this will work, but does not on my Oracle (8.0.5.0.0)-
>does not allow me to put order by in subselect. Is this problem with old
>version or ...
>
>Thanks in advance again,
>Damir.
>
>
>"Damir Mazar" <dmazar_at_interactive1.hr> wrote in message
>news:95p8od$66c$1_at_sunce.iskon.hr...
>> > Select * from (select * from files order by f_date desc)
>> > where rownum < 11;
>>
>> It seems that this does what I asked for in question. Thanks for being
>> patient and answering to this. I will search through previous posts for
>> answer in future.
>>
>> Damir.
>>
>> >
>> >
>> >
>> > "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 Tue Feb 06 2001 - 11:41:54 CST