几个常用的查询employee工资的sql语句

本文链接：https://blog.youkuaiyun.com/qq_31027515/article/details/94354758

本文提供了多个实用的SQL语句，用于查询员工薪资，包括获取最高薪资、部门内最高薪资及薪资范围等。同时，分享了编写高效SQL语句的技巧，如尽早过滤、预测下推、使用索引及避免在WHERE子句中使用不等于操作符。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

几个常用的查询employee工资的sql语句

return employee record with max salary

select * 
from employee
where salary = (select Max(salary) from employee)

select highest salary in employee table

select Max(salary) from employee

select highest salary in employee

select Max(salary)
from employee
where salary Not in (select Max(salary) from employee)

select range of employee on id

select * 
from employee
where employ_id betwween 2001 and 2011

select employee name, highest salary and department

select e.first_name, e.last_name e.salary, d.department_name
from employee e Inner Join department d
ON (e.department_id = d.department_id)
where salary IN (select Max(salary) from employee)

select employee name, highest salary and department for each department

select e.first_name, e.last_name, e.salary, d.department_name from employee e Inner join Department d ON (e.department_id = d.department_id) where salary IN (select Max(salary) from employee group by department_id)

Find Nth Highest salary in SQL

select  TOP 1 salary from 
(select DISTINCT TOP 2 salary from employee Order by salary Desc) result
Order By salary

WITH RESULT AS {
select salary, DENSE_RANK() over (Order by salary DESC) as DENSERANK
from employee 
}
Select salary
from RESULT
where RESULT.DENSERANK = 2