Re: SQL - SELECT x rows...

Joseph Ranseth wrote:

> 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

Hi Joseph,
The only way I know to do this is:

SELECT *
  FROM table
 WHERE rownum <= 100
 ORDER BY salary DESC

Should give you the 100 highest paid employees. Note the above is from memory only - I haven't actually tried it (just lazy I guess).

Cheers,
Avi. Received on Thu Aug 10 2000 - 00:00:00 CDT