mysql 分组并排序每个组

mysql group by and sort each group(mysql 分组并排序每个组)

问题描述

我有下表:

ID NAME TIME
1  A    0
2  A    3
3  B    1

我使用下面的查询产生:

I am using the query below which produces:

SELECT * FROM `table` GROUP BY `NAME`

ID NAME TIME
1  A    0
3  B    1

我想使用 GROUP BY 来生成这样的结果(按时间列折扣排序):

And I want use GROUP BY to generate a result like this (discount sort by the TIME column):

ID NAME TIME
2  A    3
3  B    1

推荐答案

SELECT NAME, MAX(TIME) as TIME 
FROM table 
GROUP BY time 
ORDER BY time DESC

这篇关于mysql 分组并排序每个组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！