题解 | #获取当前薪水第二多的员工的信息

SELECT
	emp_no, salary
FROM
	salaries 
WHERE
	salary = ( SELECT DISTINCT salary FROM salaries ORDER BY salary desc LIMIT 1 OFFSET 1 )  
ORDER BY
	emp_no ASC

这道题和 https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c 一样

都是需要使用limit结合distinct来排序并去重。