mysql实现复杂groupby : GROUP_CONCAT
摘要:
select che,GROUP_CONCAT(concat_ws(':',routeNo,num) ORDER BY num DESC SEPARATOR ',') as gg from (select che,routeNo,count(distinct paicheNo) as num from tableA where carrierType=1... 阅读全文
posted @ 2018-10-17 17:47 andy_1 阅读(1478) 评论(0) 推荐(0) 编辑