#Leetcode 176
Write a SQL query to get the second highest salary from the Employee
table.
SELECT IFNULL(
(SELECT DISTINCT salary
from Employee
Order by Salary DESC
limit 1 offset 1),NULL)
AS SecondHighestSalary
#Leetcode 176
Write a SQL query to get the second highest salary from the Employee
table.
SELECT IFNULL(
(SELECT DISTINCT salary
from Employee
Order by Salary DESC
limit 1 offset 1),NULL)
AS SecondHighestSalary