anjhon
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
http://www.nowcoder.com/questionTerminal/8d2c290cc4e24403b98ca82ce45d04db
最高工资可能有多个人, 先拿到最高工资的值, 在把这个值当作条件查员工编号和工资
select emp_no, salary
from salaries
where salary =
(select distinct salary
from salaries
order by salary desc
limit 1,1
); 