mysql groupby后选择了哪一条

结论

• 排序后 每个聚合键的第一条
• 所以可以通过排序来控制groupby的最终结果

实验

测试如下 按照uid聚合

未排序 默认主键升序

select uid,name from tmp group by uid

• 1 C
• 2 X

name升序

select * from(select uid,name from tmp order by name asc)tmp group by uid

• 1 A
• 2 X

name降序

select * from(select uid,name from tmp order by name desc)tmp group by uid

• 1 C
• 2 Z