Single-row Subquery

Single-row Subquery — A subquery that returns only one row and one column.

SELECT *
FROM employees
WHERE salary = (
    SELECT MAX(salary) FROM employees
);