Second Highest Salary

Second Highest Salary

 

Write a SQL query to get the second highest salary from the Employee table.

+----+--------+| Id | Salary |+----+--------+| 1  | 100    || 2  | 200    || 3  | 300    |+----+--------+

For example, given the above Employee table, the second highest salary is 200. If there is no second highest salary, then the query should return null.

# Write your MySQL query statement below#select e1.Salary #from Employee e1 left join Employee e2 #on e2.Salary > e1.Salary   #order by e2.Salary desc limit 1;  select max(Salary) from Employeewhere Salary < (select max(Salary) from Employee);