Re: begginer - select first X records

try with this:

select * from files where rownum < 10 order by f_date desc

Vit.

On Fri, 2 Feb 2001 17:06:01 +0100, "Hrvoje" <hmandic_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.
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Sat Feb 03 2001 - 17:30:52 CET