SELECT emp_no, salary FROM salaries WHERE salary = ( SELECT salary FROM salaries WHERE to_date = '9999-01-01' GROUP BY salary ORDER BY salary DESC limit 1 OFFSET 1 ) AND to_date = '9999-01-01'; 感觉外层也应该限制to_date = '9999-01-01'
点赞
牛客网
牛客网在线编程
牛客网题解
牛客企业服务