How to get the fourth highest value using MySQL query?

To get the fourth-highest value, use LIMIT OFFSET along with ORDER BY. Let us first create a table −

mysql> create table DemoTable
(
   Amount int
);
Query OK, 0 rows affected (0.88 sec)

Insert some records in the table using insert command −

mysql> insert into DemoTable values(980);
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable values(670);
Query OK, 1 row affected (0.19 sec)
mysql> insert into DemoTable values(890);
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable values(995);
Query OK, 1 row affected (0.25 sec)
mysql> insert into DemoTable values(198);
Query OK, 1 row affected (0.10 sec)

Display all records from the table using select statement −

mysql> select *from DemoTable;

This will produce the following output −

+--------+
| Amount |
+--------+
|    980 |
|    670 |
|    890 |
|    995 |
|    198 |
+--------+
5 rows in set (0.00 sec)

Following is the query to get the fourth-highest value −

mysql> select *from DemoTable order by Amount desc limit 1 offset 3;

This will produce the following output −

+--------+
| Amount |
+--------+
|    670 |
+--------+
1 row in set (0.00 sec)

AmitDiwan

Published on 30-Sep-2019 07:30:25

• Related Questions & Answers
• MySQL query to get the highest value from a single row with multiple columns
• MySQL query to find the top two highest scores
• MySQL query to select the nth highest value in a column by skipping values
• MySQL query to get first two highest column values from a table?
• MongoDB query to find the highest numeric value of a column?
• How to get Fourth Element of the Tuple in C#?
• Select nth highest value in MySQL
• Java Program to get the lowest and highest value in TreeSet
• How to get the 2nd highest value from a table with Student Score?
• How to order by the highest value from two columns in MySQL?
• Query MySQL database to echo highest auto incremented number?
• MySQL order by from highest to lowest value?
• How to find nth highest value of a MySQL column?
• MySQL query to merge rows if Id is the same and display the highest corresponding value from other columns
• MySQL query to get the max value with numeric values in varchar field?