为了理解这个概念，我们使用表“薪水”中的数据，如下 -
mysql> select * from salary;+--------+--------+| name | salary |+--------+--------+| gaurav | 50000 || rahul | 40000 || ram | 45000 || raman | 45000 |+--------+--------+4 rows in set (0.00 sec)mysql> select * from salary12345 order by salary desc limit 1 offset 1;+-------+--------+| name | salary |+-------+--------+| raman | 45000 |+-------+--------+1 row in set (0.00 sec)
以上就是我们如何从 mysql 表中获取员工第二高的工资？的详细内容。