SQL_LeetCode 1789_Primary Department for Each Employee 풀이 -- ORACLE, MYSQL, MSSQL SELECT EMPLOYEE_ID , DEPARTMENT_ID FROM EMPLOYEE WHERE PRIMARY_FLAG = 'Y' OR EMPLOYEE_ID IN ( SELECT EMPLOYEE_ID FROM EMPLOYEE GROUP BY EMPLOYEE_ID HAVING COUNT(DEPARTMENT_ID) = 1 ); * 출처 https://leetcode.com/problems/primary-department-for-each-employee...
SQL_LeetCode 1789_Primary Department for Each Employee에 대한 요약내용입니다.
자세한 내용은 아래에 원문링크를 확인해주시기 바랍니다.
