From: "Hrvoje" <hmandic@interactive1.hr>
Newsgroups: comp.databases.oracle
Subject: begginer - select first X records
Date: Fri, 2 Feb 2001 17:06:01 +0100
Organization: Iskon Internet d.d.
Lines: 9
Message-ID: <95elok$qnt$1@sunce.iskon.hr>
NNTP-Posting-Host: 213.191.143.55
X-Trace: sunce.iskon.hr 981129812 27389 213.191.143.55 (2 Feb 2001 16:03:32 GMT)
X-Complaints-To: abuse@iskon.hr
NNTP-Posting-Date: 2 Feb 2001 16:03:32 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


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.