MySQL-Second Highest Salary

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 second highest salary is 200. If there is no second highest salary, then the query should return null.

代码：

SELECT IFNULL( (SELECT distinct Salary as SecondHighestSalary FROM Employee order by Salary desc limit 1,1) ,null) as SecondHighestSalary;

或：

SELECT MAX(Salary)FROM Employee WHERE Salary < (SELECT MAX(Salary)FROM Employee);

或：

SELECT (SELECTDISTINCT Salary FROM Employee ORDERBY Salary DESC LIMIT 1,1);

或：

SELECT MAX(Salary) FROM Employee E1
WHERE 1 =
(SELECT COUNT(DISTINCT(E2.Salary)) FROM Employee E2
WHERE E2.Salary > E1.Salary);

注意MySQL语法中的LIMIT的用法：
select * from table limit m,n
其中m是指记录开始的index，从0开始，表示第一条记录，n是指从第m+1条开始，取n条。
Example：
select * from tablename limit 2,4
即取出第3条至第6条，4条记录。
注意mysql语法中的DISTINCT的用法：
mysql提供有distinct这个关键字来过滤掉多余的重复记录只保留一条。

注意mysql语法的IFNULL关键字的用法：
MYSQL IFNULL(expr1,expr2)          
如果expr1不是NULL，IFNULL()返回expr1，否则它返回expr2。IFNULL()返回一个数字或字符串值，取决于它被使用的上下文环境。
   
   
1
2