> For the complete documentation index, see [llms.txt](https://404dream.gitbook.io/mysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://404dream.gitbook.io/mysql/summary/examples-of-common-queries/the-maximum-value-for-a-column.md).

# 4.6.1 列的最大值

“最高（最低）的物品号是多少？”

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

\==来自评论区==

最低则用 MIN()

平均则用 AVG()

求和则用 SUM()