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
查询结果