Re: selecting top performers

baroo wrote:
> Hi
>
> How do I select the top 20 earners from my database?
>
> urgent.
>
> cheers
>

The simplest top(n) query you can write:

SELECT a.earnings FROM
(SELECT earnings FROM
  YOUR_TAB
  ORDER BY earnings DESC
)a
WHERE ROWNUM < 21

Regards,
Amogh Received on Mon Aug 08 2005 - 08:18:04 CDT