select em.emp_no,salary,last_name,first_name from employees em join salaries sl on em.emp_no = sl.emp_no where salary = (
SELECT s1.salary FROM salaries s1 JOIN salaries s2 ON s1.salary <= s2.salary GROUP BY s1.salary HAVING COUNT(s2.salary) = 2
);

京公网安备 11010502036488号