GROUP_CONCAT()的使用

– 查询标准重复的次数 将重复的标准号的所属企业串联起来放在一个字段中（GROUP_CONCAT(t.enterprise)）

select * from (select t.standardid1,GROUP_CONCAT(t.enterprise),count(t.id) as num from collect t GROUP BY t.standardid1) t1
order by t1.num desc

– 查询重复的标准号次数 将重复的标准号的所属企业串联起来放在一个字段中（GROUP_CONCAT(t.enterprise)）和所有的字段

select t1.,t3. from (select t.standardid1,GROUP_CONCAT(t.enterprise),count(t.id) as num from collect t GROUP BY t.standardid1) t1
left join (select t2.id,max(t2.standardid2),max(t2.standardName),t2.standardid1,t2.standardEname,t2.enterprise,t2.standardType,t2.standardorganization1,t2.standardOrganization2,t2.major,t2.type,t2.rawId from collect t2 group by t2.standardid1 ) t3 on t3.standardid1=t1.standardid1
order by t1.num desc