为未按数字计算的员工表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