如何获得最高工资 [英] How to get n th max salary

问题描述

如何在sql server查询中获得第n个最高工资，请建议我简单查询

解决方案

DECLARE @COUNT INT



SELECT TOP 1 Salary FROM（按工资DESC从SELECT员工薪酬订单中选择TOPCOCO DISTINCT薪资）按工资ASC排序问题

  SELECT  *来自Employee_Test_salary 
 
  go  
 
 < span class =code-keyword>  emplsal  as （
  SELECT  Emp_Sal，DENSE_RANK（） over （ order   by  Emp_Sal  desc ） as  rownumber 
 来自 Employee_Test_salary 
）
 选择  top  < span class =code-digit> 1  Emp_Sal 来自 emplsal 其中 emplsal.rownumber = ñ

How to get n th max salary in sql server query , please suggest me simple query

解决方案

DECLARE @COUNT INT

SELECT TOP 1 Salary FROM( SELECT TOP @COUNT DISTINCT Salary FROM EmployeeSalary ORDER BY Salary DESC ) Q ORDER BY Salary ASC

SELECT *from Employee_Test_salary

go

with emplsal as(
	SELECT Emp_Sal ,DENSE_RANK() over (order by Emp_Sal desc) as rownumber
	from Employee_Test_salary  
)
select top 1 Emp_Sal from emplsal where emplsal.rownumber =N

这篇关于如何获得最高工资的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！