SELECT
emp_no,
salary
FROM
salaries
WHERE
to_date = '9999-01-01'
AND salary = (
SELECT DISTINCT
salary
FROM
salaries
ORDER BY
salary DESC
LIMIT 1,
1
)
**注意:**薪水相同的情况可能存在,要用distinct或者group by去重
SELECT
emp_no,
salary
FROM
salaries
WHERE
to_date = '9999-01-01'
AND salary = (
SELECT DISTINCT
salary
FROM
salaries
ORDER BY
salary DESC
LIMIT 1,
1
)
**注意:**薪水相同的情况可能存在,要用distinct或者group by去重