Re: selecting top performers

From: Robert Klemme <bob.news_at_gmx.net>
Date: Mon, 8 Aug 2005 15:49:23 +0200
Message-ID: <3lp676F13oli6U1@individual.net>

amogh wrote:
> 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

If I'm not mistaken you can even omit the query nesting and use the ROWNUM filter on the inner query directly.

robert Received on Mon Aug 08 2005 - 08:49:23 CDT