帮助我关于SQL查询 [英] help me regarding sql query

问题描述

任何人都可以帮我解决这个问题！

写一个查询来查找表客户的第二高工资？

can anyone help me with this query!
write a query to find 2nd highest paid salary from the table customer?

推荐答案

http://stackoverflow.com/questions/2160262/query-for-第二个最高薪水来自员工表 [ ^ ]



sql查询以查找第二个最高薪水 [ ^ ]

select MAX(Salary) from Employees
WHERE Salary <> (select MAX(Salary) from Employees) -- works with any version

Select * From Employees -- For Sql Server 2012 only...
Order by Salary Desc
Offset 1 Rows
Fetch Next 1 Rows only;

第N个最高工资

这篇关于帮助我关于SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！