MySQL 8.0 参考手册  / 第 3 章教程  / 3.6 常见查询示例  /  3.6.3 每组最大列数

3.6.3 每组最大列数

任务:找到每篇文章的最高价格。

Press CTRL+C to copy
SELECT article, MAX(price) AS price FROM shop GROUP BY article ORDER BY article; +---------+-------+ | article | price | +---------+-------+ | 0001 | 3.99 | | 0002 | 10.99 | | 0003 | 1.69 | | 0004 | 19.95 | +---------+-------+