1、查询emp_no, salary:SELECT emp_no, salary
2、从salary中查询:FROM salary
3、查询第二大:
(1)将salary倒序:ORDER BY salary DESC
(2)只取第二条信息:LIMIT 1 OFFSET 2
4、串联:
SELECT emp_no, salary
FROM salary
ORDER BY salary DESC
LIMIT 1 OFFSET 2