第二高查询

编写一个 SQL 查询,获取 Employee表中第二高的薪水(Salary)。

+----+--------+
| Id | Salary |
+----+-------sqlserver端口号-+
|神祇领主时代 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
例如上述Employee表,SQL查询应该返回200 作为第二高的薪水。如果不存在第二高的薪水,那么查询应返回宋庆玲 null。

+sqlserver内存最佳配置---------------------+
| SecondHighestSalary |
+---------------------+
| 200 |
+----------------sql查询最后一条数据-----+sql查询前10条记录



                                            第二高查询



                                            第二高查询



                                            第二高查询


/*查询第一高的薪资*/
/*
SELECT IFNULL(
(SELECT DISTINCT salary
FROM employee
ORDER BY salary
DESC LIMIT 0,1),NULL)
AS HighestSalary
*/

/*查询第二高的薪资*/
SELECT IFNULL(
(SELECT DISTINCT salary
FROM employee
ORDER BY salary
DESC LIMIT 1,1),NULL)
AS SecondHighestSalary

/*查询第三高的薪资*/
/*
SELECT IFNULL(
(SELECT DISTINCT salary
FROM employee
ORDER BY salary
DESC LIMIT 2,1),NULL)
AS ThirdHighestSalary
*/