leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1965.sql (240B)
0 SELECT employee_id
1 FROM (
2 SELECT * FROM Employees LEFT JOIN Salaries USING(employee_id)
3 UNION
4 SELECT * FROM Employees RIGHT JOIN Salaries USING(employee_id)
5 ) AS T
6 WHERE salary IS NULL OR
7 name IS NULL
8 ORDER BY employee_id