Mysql partition by

一，看原表

select * from `user`;

 

 

二，查询同组年级最大的

select 
username
,SUBSTRING_INDEX( GROUP_CONCAT(age order by age desc) ,',',1) uuid 
from 
(
select uuid
,username
,`password`
,age
from `user`
)b 
GROUP BY uuid asc;

 

转载于:https://www.cnblogs.com/hanjun0612/p/10063802.html