Mysql partition by
一,看原表select * from `user`;二,查询同组年级最大的selectusername,SUBSTRING_INDEX( GROUP_CONCAT(age order by age desc) ,',',1) uuidfrom(select uuid,username,`password`,agefrom `u...
·
一,看原表
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
where (CreateTime,userId) in
(select max(CreateTime),userId from user group by userId);
更多推荐
已为社区贡献9条内容
所有评论(0)