select taskid, count(distinct(uid)) as uid from es_battle_pvp where uid IN ( select GROUP_CONCAT(distinct(uid)) as uid from es_battle_pvp group by uid ) group by taskid
Mysql in里面嵌套子查询
最新推荐文章于 2024-06-18 10:49:27 发布
select taskid, count(distinct(uid)) as uid from es_battle_pvp where uid IN ( select GROUP_CONCAT(distinct(uid)) as uid from es_battle_pvp group by uid ) group by taskid