leetcode

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

0176.sql (175B)

0 SELECT CASE
1 WHEN COUNT(salary)=1 THEN NULL
2 ELSE (SELECT DISTINCT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 1)
3 END AS secondHighestSalary
4 FROM Employee