Re: begginer - select first X records

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 - 10:51:24 CST