LeetCode_Mysql_Second Highest Salary, leetcode

LeetCode_Mysql_Second Highest Salary, leetcode
176. Second Highest Salary

1. Problem description:

Write an SQL statement to get the second highest salary from the Employee table.

2. solution:

This question is very simple, so it is time to warm up. First, use max to find the highest salary;
Then, find the highest salary less than the highest salary, which is the second highest salary.

3. SQL statement:

Select Max (Salary) from Employee where Salary <(select Max (Salary) from Employee)

4. Run Time:

I hope to give you more comments!

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.