group_concat()函数 排序

SELECT
buName,
GROUP_CONCAT( MONTH ORDER BY MONTH DESC ) AS m,
GROUP_CONCAT( profit ORDER BY MONTH DESC ) AS profit 
FROM
t1 
GROUP BY
buName;

  

posted on 2020-11-19 11:25  滚动的蛋  阅读(207)  评论(0编辑  收藏  举报

导航