Re: SQL - SELECT x rows...

No

if you do an explain plan on this you'll see that Oracle gets 100 rows THEN does the order by. As Mark said you need to do a subquery to do a TOP N. "Avi Abrami" <aabrami_at_intersystemsww.com> wrote in message news:39924620.BFC59CAC_at_intersystemsww.com...
> 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