mysql - 查找雇员表 MySQL 的最大和第二最大工资，不按数字计算

Question

我想要此表中的第二个最高工资

mysql> select * from Employee;                                                                                                                                          
+------+---------+--------+                                                                                                                                             
| id   | name    | salary |                                                                                                                                             
+------+---------+--------+                                                                                                                                             
| 1    | shubham | 200    |                                                                                                                                             
| 2    | geeta   | 300    |                                                                                                                                             
| 3    | nir     | 500    |                                                                                                                                             
| 4    | pooja   | 2000   |                                                                                                                                             
| 5    | pranav  | 5000   |                                                                                                                                             
+------+---------+--------+ 

Answer 1

您可以运行此查询以获得第二高的薪水

SELECT * FROM Employee ORDER BY Salary DESC LIMIT 1 OFFSET 1