Community Learn Tools Library Leisure

English

Home > Database > Mysql Tutorial > How can we get the second highest salary of an employee from a MySQL table?

How can we get the second highest salary of an employee from a MySQL table?

王林

Release： 2023-08-25 22:09:25

forward

1055 people have browsed it

我们如何从 MySQL 表中获取员工第二高的工资？

To understand this concept, we use the data from table "Salary" as follows -

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)

Copy after login

The above is the detailed content of How can we get the second highest salary of an employee from a MySQL table?. For more information, please follow other related articles on the PHP Chinese website!

source：tutorialspoint.com

Previous article：How do we delete a MySQL view from the database? Next article：What will MySQL return if the argument to the QUOTE() function is NULL?

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn