Re: begginer - select first X records

Remember, no SQL database guarantees the order of the records being returned.

To get the first '5 rows', use the order clause. The RowNum virtual column is created on the fly so it can be used as a counter.

/Hans

yufufi wrote:

> SELECT * FROM BILLS WHERE ROWNUM< 5 ;
>
> "Hrvoje" <hmandic_at_interactive1.hr> wrote in message
> news:95elok$qnt$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.
> >
> >
Received on Fri Apr 27 2001 - 07:44:33 CEST