如何从薪水表中获得第3个最高薪水？ [英] HOW to get 3rd Maximum salary from salary table?

问题描述

任何人都可以帮我查询吗？

Can Any one Help me with query?

推荐答案

试试这个很棒的查询

选择* from（select dense_rank（）over （按工资desc排序）作为等级，*来自表格）aa其中aa.rank = N



这里N是salry的数量，如第3，第4，第5等。 。

Try this it's awesome query
Select * from (select dense_rank() over (order by salary desc) as rank,* from table)aa where aa.rank=N

here N is count of salry like 3rd,4th,5th etc..

USe



SELECT TOP 1 Salary FROM（按工资DESC从EmployeeSalary订单中选择前3工资）Q ORDER BY Salary ASC

USe

SELECT TOP 1 Salary FROM( SELECT TOP 3 Salary FROM EmployeeSalary ORDER BY Salary DESC ) Q ORDER BY Salary ASC

SELECT TOP 1 Salary

FROM（

SELECT DISTINCT TOP 3 Salary

来自员工

工资订单DESC

）AS Emp

工资订单

这篇关于如何从薪水表中获得第3个最高薪水？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！