Leetcode刷题 SQL 难度：易

Problem 176

Second Highest Salary

Posted by Ruizhi Ma on July 3, 2019

问题描述

https://leetcode.com/problems/second-highest-salary/

解决思路

先找到最高的，再找到比最高的低的，就是第二高的Salary了

代码

# Write your MySQL query statement below
Select max(Salary) as SecondHighestSalary
From Employee
WHERE Salary <(SELECT max(Salary)
                From Employee);