Re: Get first 10 records?
From: TurkBear <noone_at_nowhere.com>
Date: Wed, 17 Oct 2001 10:43:51 -0500
Message-ID: <ej9rstce85qa0gvs0rntkjso60cdhkjh7l_at_4ax.com>
Date: Wed, 17 Oct 2001 10:43:51 -0500
Message-ID: <ej9rstce85qa0gvs0rntkjso60cdhkjh7l_at_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 - 17:43:51 CEST