인프런 커뮤니티 질문&답변

윈도우 함수는 where절에서는 사용할 수 없나요?!

SELECT department.name,
        employee.name,
        employee.salary, 
FROM Employee E Inner Join Department D ON E.departmentId = D.id
WHERE employee.salary = MAX(salary) OVER(PARTITION BY departmentId) AS max_salary