leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1789.sql (181B)
0 SELECT employee_id, department_id
1 FROM Employee
2 GROUP BY employee_id
3 HAVING COUNT(department_id) = 1
4 UNION
5 SELECT employee_id, department_id
6 FROM Employee
7 WHERE primary_flag = 'Y'