mysql 分组并排序每个组

2021-12-27 00:00:00 sql sorting group-by 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

相关文章