SELECT SUBSTRING_INDEX(GROUP_CONCAT(coupon_type ORDER BY cd_type ),',',1) as cd_type FROM tab WHERE cd_id = 102 GROUP BY cd_id HAVING (cd_type != 0)
MySQL分组(group_concat)取第一条
于 2021-07-23 11:20:51 首次发布
SELECT SUBSTRING_INDEX(GROUP_CONCAT(coupon_type ORDER BY cd_type ),',',1) as cd_type FROM tab WHERE cd_id = 102 GROUP BY cd_id HAVING (cd_type != 0)