select e.emp_no,s.salary,e.last_name,e.first_name
from employees e
join salaries s
on s.emp_no = e.emp_no
and s.to_date='9999-01-01'
and s.salary =
    (select salary
        from salaries s
          where salary<(
            select salary 
            from salaries
            where to_date='9999-01-01'
            HAVING salary=max(salary)
                       )
          and to_date='9999-01-01'
          HAVING salary=max(salary)
    );

在本地mysql测试的数据和结果一样，为什么通过不了，神奇.....