Re: begginer - select first X records

From: Damir Mazar <dmazar_at_interactive1.hr>
Date: Tue, 6 Feb 2001 17:31:11 +0100
Message-ID: <95p8od$66c$1@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:31:11 CST