select
emp_no,
salary
from salaries
where to_date='9999-01-01'
order by salary
desc limit 1,1

limit 页数（0开始）,每页显示条数
limit 1,1 就是查询第二页的第一条