WITH max_salary AS ( SELECT MAX(salary) max_salary FROM salaries ) SELECT s.empno FROM salaries s JOIN max_salary ms ON s.salary = ms.max_salary

max_salary AS (
    SELECT 
        MAX(salary) max_salary
    FROM 
        employees
)
SELECT 
    *
FROM 
    employees
WHERE 
    salary = max_salary

A:

You can use a correlated subquery:
SELECT *
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees);

A:

You can use a correlated subquery