Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL PUZZLE: selecting top 50 salaries in a table
I don't have Oracle in front of me but please try below where n is how many
top records to select, MySalaryTable has the salary information and
determinant is any other condition (the 50 top salaries for 1997 for
example). This query should allow for ties, which in the case of salaries,
are likely to occur.
SELECT
sal1.salary,
(SELECT
COUNT(DISTINCT salary)
FROM
MySalaryTable sal2
WHERE
sal2.salary >= sal1.salary and sal2.determinant = sal1.determinant) as rankingFROM
ranking <= &n
;
Van
NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
news:380f8e89.268436409_at_news.earthlink.net...
> Well.. we know how to select top salary, which is select max(salary),
> but how would I select top 50 records?
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Thu Oct 21 1999 - 18:36:13 CDT