查询表中薪资第二高:
思路:
Step1 : 获取不包含最高薪资的子表信息;
Step2 : 获取子表中的最高薪资
完整SQL如下:
SELECT MAX(Salary) FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee);
查询表中薪资第二高:
思路:
Step1 : 获取不包含最高薪资的子表信息;
Step2 : 获取子表中的最高薪资
完整SQL如下:
SELECT MAX(Salary) FROM Employee
WHERE Salary < (SELECT MAX(Salary) FROM Employee);