GNU Info

(mysql.info)example-Maximum-column-group

---

Next: example-Maximum-column-group-row Prev: example-Maximum-row Up: Examples

---

Enter node , (file) or (file)node

Maximum of Column per Group
---------------------------

"What's 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 |
     +---------+-------+