Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT salaries.emp_no, first_name, last_name, MAX(salary) FROM employees JOIN salaries ON employees.emp_no = salaries.emp_no WHERE salary = (SELECT MAX(salary)FROM salaries)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement