select a.emp_no, b.salary, a.last_name, a.first_name from employees as a inner join salaries as b on a.emp_no= b.emp_no where b.salary = (select max(salary) from salaries where salary != (select max(salary) from salaries));
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务