leetcode 176. Second Highest Salary
# Write your MySQL query statement below
select (select distinct Employee.Salary from Employee order by Employee.Salary desc limit 1 offset 1) as SecondHighestSalary;
TODO:
distinct 和 offset的理解运用
# Write your MySQL query statement below
select (select distinct Employee.Salary from Employee order by Employee.Salary desc limit 1 offset 1) as SecondHighestSalary;
TODO:
distinct 和 offset的理解运用