MySql_176. 第二高的薪水 + limit + distinct + null

MySql_176. 第二高的薪水

LeetCode_MySql_176

题目描述

题解分析

代码实现

# Write your MySQL query statement below
select(
    select distinct Salary 
        from Employee
        order by Salary desc
        limit 1 offset 1) as SecondHighestSalary;