# Write your MySQL query statement below
Select ifnull((SELECT distinct salary
from Employee
order by Salary desc limit 1,1),null)as SecondHighestSalary
176. 第二高的薪水# Write your MySQL query statement belowSelect ifnull( (SELECT distinct salary from Employee order by Salary desc limit 1,1 ),null) as SecondHighestSalary此题思路还是正常的SQL查询语句的思路:(1)查找第二高的薪水,则需要先对查找的结果进行排序,然后去重,再使用limit1,1