176. Second Highest Salary

来源:互联网 发布:mac版的rar 解压软件 编辑:程序博客网 时间:2024/06/05 15:26

Write a SQL query to get the second highest salary from the Employee table.

+----+--------+| Id | Salary |+----+--------+| 1  | 100    || 2  | 200    || 3  | 300    |+----+--------+

For example, given the above Employee table, the query should return 200 as the second highest salary. If there is no second highest salary, then the query should returnnull.

+---------------------+| SecondHighestSalary |+---------------------+| 200                 |+---------------------+                                                                                                                                        code:# Write your MySQL query statement belowselect distinct Salary as SecondHighestSalary from Employee order by Salary desc limit 1 offset 1 
原创粉丝点击