如何在SQL服务器中获得第三高薪 [英] How to get third highest salary in SQL server

问题描述

员工表格如下

Employee table as follows

Name	Salary
Ram     12000
Asif	15000
Suresh	15000
mohan	18000
Bhuva	19000
asif	25500
Pavan	34000

i想要使用上面的员工表获得第三高工资。



我尝试过：



（删除重复）

i want to get the third highest salary using the above Employee table.

What I have tried:

(removed repetition)

推荐答案

尝试：

Try:

WITH myTableWithRows AS (
	SELECT (ROW_NUMBER() OVER (ORDER BY myTable.Salary DESC)) as row,*
	FROM myTable)
SELECT * FROM myTableWithRows WHERE row = 3

或：

Or:

SELECT * 
FROM (
    SELECT *, ROW_NUMBER() OVER (ORDER BY Salary DESC) AS RowNum
    FROM [MyTable]   
) AS MyDerivedTable
WHERE MyDerivedTable.RowNum = 3

这篇关于如何在SQL服务器中获得第三高薪的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！