解法三是错的，我觉得应该再套一层子查询 SELECT emp_no, salary FROM salaries WHERE salary = ( select max(salary) as salary from salaries where salary <> ( select max(salary) from salaries where to_date='9999-01-01' ) );