Skip navigation links

Additional languages
MySQL 6.0 Reference Manual :: 3 Tutorial :: 3.6 Examples of Common Queries :: 3.6.3 Maximum of Column per Group
3.6.4 The Rows Holding the Group-wise Maximum of a Certain Field »
Section Navigation      [Toggle]

3.6.3. Maximum of Column per Group

Task: Find the highest price per article. 

SELECT article, MAX(price) AS price
FROM   shop
GROUP BY article;

+---------+-------+
| article | price |
+---------+-------+
|    0001 |  3.99 |
|    0002 | 10.99 |
|    0003 |  1.69 |
|    0004 | 19.95 |
+---------+-------+

User Comments

Posted by Marco Gergele on September 30 2004 10:24am[Delete] [Edit]

There seems to be no NULL=Infinity maximum version. In a column is stored end (type date) with NULL = no end. I need the maximum of that column, which is NULL if a NULL-value exists. That should be easy to implement as a function, but not so easy with the existing function.

The same for sum, avg and so on. The versions with NULL=ignore are usefull most of the time, but sum() of NULL and 5 can sometimes be NULL instead of 5. NULL+5 is NULL.

Add your own comment.