SELECT s.emp_no,s.salary,e.last_name,e.first_name FROM salaries s JOIN employees e ON s.emp_no = e.emp_no WHERE salary = ( SELECT max(salary) as secondmax_salary FROM salaries s1 WHERE salary < ( SELECT max(salary) as max_salary FROM salaries s ) )
SELECT s.emp_no,s.salary,e.last_name,e.first_name FROM salaries s JOIN employees e ON s.emp_no = e.emp_no WHERE salary = ( SELECT max(salary) as secondmax_salary FROM salaries s1 WHERE salary < ( SELECT max(salary) as max_salary FROM salaries s ) )