GROUP_CONCAT(DISTINCT xxx.`xxx`) 使用

项目场景：

mysql分组查询

例如：例如要查询三个属性，需要对前两个属性去重，第三个结果进行去重并分组

---

问题描述

SELECT 
ssav.`attr_id`,
ssav.`attr_name`,
ssav.`attr_value`
FROM `pms_sku_info` info
LEFT JOIN `pms_sku_sale_attr_value` ssav ON ssav.`sku_id` = info.`sku_id`
WHERE info.`spu_id` = 1 GROUP BY ssav.`attr_id`,ssav.`attr_name`,ssav.`attr_value`

---

解决方案：

使用GROUP_CONCAT(DISTINCT ssav.attr_value)

SELECT 
ssav.`attr_id`,
ssav.`attr_name`,
GROUP_CONCAT(DISTINCT ssav.`attr_value`)
FROM `pms_sku_info` info
LEFT JOIN `pms_sku_sale_attr_value` ssav ON ssav.`sku_id` = info.`sku_id`
WHERE info.`spu_id` = 1 GROUP BY ssav.`attr_id`,ssav.`attr_name`