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