题解 | SQL211

select
emp_no
,salary
from salaries
where salary =(SELECT DISTINCT salary
FROM salaries
order by salary desc
limit 1,1 /*查出第二多工资具体数值*/)
order by emp_no 
/*where +子查询*/

select
AA.emp_no
,AA.salary
from 
(select 
emp_no
,salary
,dense_rank()over(order by salary desc) as ra
from salaries) as AA
where AA.ra=2

--from+子查询