Re: How to extract "nn" row from a table

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Fri, 5 Jun 1998 09:17:03 +0100
Message-ID: <6l89h3$hf4$1@schbbs.mot.com>

Of course, this will only work if you're not ordering. Remember that the test against rownum is applied to the records as they are pulled out of the database so if you have an order by in your select statement you may not get the ten you are expecting is the top ten after the order by is applied. You'll get what appears to be a random ten from the full list.

--
Alan D. Mills

To email remove NOSPAM from address.
TurkBear wrote in message <35758903.13873769_at_news2.mm.com>...
>"Jean-Gwilherm Praud" <jgp_at_comx.fr> wrote:
>
>>Hello,
>>
>>I Have to extract just the 10 first results row of my sql query !
>>how can I do simply.
>>
>>Thank.
>>
>>
>and where rownum < 11 to your query,,,,,
>
>
Received on Fri Jun 05 1998 - 03:17:03 CDT