MYSQL:

select emp_no,salary
from salaries
order by salary desc
limit 1,1;

 

posted on 2021-10-12 15:03  Sempron2800+  阅读(27)  评论(0编辑  收藏  举报