一、题目
二、代码
# select *
# from salaries sa
# order by
/*
因为会有重复
所以需要第一张表 查出 薪水第二高的数值
与另一张表连接
*/
# select distinct salary
# from salaries sa
# order by salary desc
# limit 1,1
select sa.emp_no,sa.salary
from salaries sa
where sa.salary =
(
select distinct salary
from salaries sa
order by salary desc
limit 1,1
)