SELECT e.emp_no, s3.salary, e.last_name, e.first_name FROM employees e JOIN salaries s3 on e.emp_no=s3.emp_no WHERE s3.to_date='9999-01-01' and s3.salary=( SELECT max(salary) FROM salaries s2 WHERE to_date='9999-01-01' and s2.salary<( SELECT max(salary) FROM salaries WHERE to_date='9999-01...