leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1789.sql (181B)


      1 SELECT employee_id, department_id
      2 FROM Employee
      3 GROUP BY employee_id
      4 HAVING COUNT(department_id) = 1
      5 UNION
      6 SELECT employee_id, department_id
      7 FROM Employee
      8 WHERE primary_flag = 'Y'