Re: SQL - SELECT x rows...

Try it with .....where rownum <21 or <101

• but this will only work when you set 'order by' in a way that the required records will be the first ones to be shown -

Rgds Raphaela

"Joseph Ranseth" <jransethNO_SPAM_at_worldcupfishing.com> schrieb im Newsbeitrag news:BKgk5.14$Lc.1764_at_news1.mts.net...
> How can I select 'x' number of rows from/in a query?
>
> ie: I want to select the 20 oldest employees, or 100 highest paid, etc.
>
> Is there a simple way of going about this, or do I have to select all of
 the
> records and then only print the desired amount (That wouldn't be
 efficient,
> though, would it?)
>
> Thanks in Advance,
>
> JR
>
>
Received on Wed Aug 09 2000 - 00:00:00 CDT