本文介绍了mysql分组并对每个组进行排序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有下表:
I have the following table:
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 来生成这样的结果(按TIME列排序):
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分组并对每个组进行排序
发布评论