Skip navigation links
3.6.2 The Row Holding the Maximum of a Certain Column »
Section Navigation      [Toggle]

3.6.1. The Maximum Value for a Column

“What is the highest item number?” 

SELECT MAX(article) AS article FROM shop;

+---------+
| article |
+---------+
|       4 |
+---------+

User Comments

Posted by Najeem M Illyas on November 13 2004 6:03am[Delete] [Edit]

Similarly MIN can be used to find minium value

SELECT MIN(jnr_id) AS jnr_id FROM chain

+----------+
|  jnr_id  |
+----------+
|   1000   |
+----------+

Posted by Andy Pieters on February 6 2005 8:06pm[Delete] [Edit]

You can use just about any function in a select query.

Besides the MAX, and MIN functions, there is also the AVG function to quickly calculate the Average value of a field.

* The AS parameter sets the name of the field that is outputted

Example:

SELECT avg(article) AS article_avg FROM shop;

+-------------+
| article_avg |
+-------------+
|      2.4286 |
+-------------+
1 row in set (0.00 sec)

Posted by Alex Grim on December 13 2006 8:26am[Delete] [Edit]

Also, you can use sum:

mysql> select sum(article) as Total from shop;

+-------+
| Total |
+-------+
|    17 | 
+-------+


Posted by Sony George on February 18 2010 3:36pm[Delete] [Edit]

How to display 4th highest (salary) record from customer table:

mysql> SELECT sal FROM `emp` order by sal desc limit 3,1

Add your own comment.