leetcodeSolution 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