一,看原表
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;
一,看原表
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