Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Get first 10 records?

Re: Get first 10 records?

From: TurkBear <noone_at_nowhere.com>
Date: Wed, 17 Oct 2001 10:43:51 -0500
Message-ID: <ej9rstce85qa0gvs0rntkjso60cdhkjh7l@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US