_176. Second Highest Salary.md

176. Second Highest Salary

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 43.05 %

---

Solutions

• m176.sql

SQL

m176.sql

SELECT IFNULL(
    (SELECT DISTINCT salary
        FROM Employee e
        ORDER BY salary DESC
        LIMIT 1 OFFSET 1),
    NULL) 
    AS 'SecondHighestSalary';