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)

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