Re: begginer - select first X records

From: yufufi <yufufi_at_turk.net>
Date: Sun, 4 Feb 2001 22:01:04 +0200
Message-ID: <95mgp5$l0t1_at_baran22.ttnet.net.tr>


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 Sun Feb 04 2001 - 21:01:04 CET

Original text of this message