编写一个 SQL 查询,获取 Employee 表中第二高的薪水(Salary)
Employee :
Id | Salary |
---|---|
1 | 100 |
2 | 200 |
3 | 300 |
答:
select distinct salary from Employee
order by salary limit 1,1;
-
select distinct : 去重后返回唯一值,例子详见select distinct
-
limit 1,1 : 从第二个开始,检索1个,也就是第二个
-
limit更多例子:
SELECT * FROM orange LIMIT 10,15; // 检索记录11-25 , 从第11个开始,检索15个
SELECT * FROM orange LIMIT 100,-1; // 检索记录101-last