SELECT e.emp_no, s.salary, e.last_name, e.first_name
From employees e join salaries s
ON e.emp_no = s.emp_no
WHERE s.to_date = '9999-01-01'
ORDER BY s.salary DESC
LIMIT 1, 1