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='9...