Question

在库克服务器中,我正设法获得5名最高工资。

我的薪水一样。

和我一样

Answer 1

如果你想获得五位最高的单独薪金(无论数额多少倍可能显示),你需要使用<条码> DENSE_RANK(的排名职能和一个计算中心来做到这一点:

DECLARE @salaries TABLE (salary DECIMAL(18,4))

INSERT INTO @salaries VALUES(5000)
INSERT INTO @salaries VALUES(5000)
INSERT INTO @salaries VALUES(4500)
INSERT INTO @salaries VALUES(4500)
INSERT INTO @salaries VALUES(3000)
INSERT INTO @salaries VALUES(2000)
INSERT INTO @salaries VALUES(1000)
INSERT INTO @salaries VALUES(500)
INSERT INTO @salaries VALUES(400)

;WITH SalariesRanked AS
(
    SELECT 
        Salary, 
        SalaryNumber = DENSE_RANK() OVER(ORDER BY Salary DESC)
    FROM    
        @salaries
)
SELECT salary
FROM SalariesRanked 
WHERE SalaryNumber <= 5

结果是产生了这样的产出:

Answer 2

SELECT TOP 5 salary FROM your_table
ORDER BY salary DESC

Answer 3

select salary
from
  (
    select salary,
           dense_rank() over(order by salary desc) as rn
    from YourTable
  ) as T
where rn <= 5

Try on SE-Data

Answer 4

SELECT TOP 5 Salary
FROM [Table]
GROUP BY Salary
ORDER BY Salary DESC

你们需要把问题分类,以避免重复的工资。

友情链接