leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

0184.sql (257B)

1 SELECT D.name AS Department, 2 E.name AS Employee, 3 E.salary 4 FROM Employee E 5 LEFT JOIN Department D 6 ON E.departmentId = D.id 7 WHERE (D.id, E.salary) IN ( 8 SELECT departmentId, MAX(salary) AS salary 9 FROM Employee 10 GROUP BY departmentId 11 )