Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Get first 10 records?
The replies you will get will work ( select * from whatever where rownum < 11); however, these are not the 'first' 10 records
since 'first' has no real meaning in a RDBMS - you will get the 10 records that are 'found' first by the query....
harry <a_at_abc.com> wrote:
>Using Oracle 8i 8.1.7
>
>Is it possible to return just the first say 10 records from a select statment?
>
>thanks
>
>harry
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Oct 17 2001 - 10:43:51 CDT