mysql GROUP BY 字符相加

来源:互联网 发布:免费发帖软件 编辑:程序博客网 时间:2024/05/22 07:57

SELECT GROUP_CONCAT(a)
FROM (
SELECT 'a' AS a,1 AS b,2 AS c
UNION ALL
SELECT 'b' AS a,1 AS b,2 AS c
UNION ALL
SELECT 'd' AS a,1 AS b,2 AS c
UNION ALL
SELECT 'd' AS a,1 AS b,2 AS c
UNION ALL
SELECT 'e' AS a,1 AS b,4 AS c
) AS bb

GROUP BY b,c

 

查询结果

 

0 0
原创粉丝点击