HTMLify
Q176_Second_Highest_Salary.sql
Views: 327 | Author: djdj
select
(select distinct salary as SecondHighestSalary from Employee
order by salary desc limit 1,1) as SecondHighestSalary;
select
(select distinct salary as SecondHighestSalary from Employee
order by salary desc limit 1,1) as SecondHighestSalary;