Answer: How To Use DISTINCT With a Join?

SELECT employees.emp_no, employees.first_name, employees.last_name, employees.gender MAX(salaries.salary) AS salary FROM employees JOIN salaries ON employees.emp_no = salaries.emp_no GROUP BY employees.emp_no ORDER BY salary DESC LIMIT 10; 

+--------+------------+-----------+--------+--------+ | emp_no | first_name | last_name | gender | salary | +--------+------------+-----------+--------+--------+ | 43624 | Tokuyasu | Pesch | M | 158220 | |