GNU Info

(mysql.info)example-Maximum-column

---

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

---

Enter node , (file) or (file)node

The Maximum Value for a Column
------------------------------

"What's the highest item number?"

     SELECT MAX(article) AS article FROM shop
     
     +---------+
     | article |
     +---------+
     |       4 |
     +---------+