Multiple-column Subquery — A subquery that returns multiple rows and columns.
SELECT * FROM employees WHERE (department, salary) IN ( SELECT department, MAX(salary) FROM employees GROUP BY department );
Clickable & Draggable!
Semantic portal