select emp_no,salary from salaries
order by salary desc limit 1 offset 1
select emp_no,salary from salaries
order by salary desc limit 1,1
select emp_no,salary from salaries
order by salary desc limit 1 offset 1
select emp_no,salary from salaries
order by salary desc limit 1,1
牛客博客，记录你的成长
京公网安备 11010502036488号