MySQL分组组内排序
group_concat()函数的参数是可以直接使用order by排序的。
SELECT a.brand_name as brandName,
GROUP_CONCAT(b.id,'=',car_model order by b.create_time desc) as cars
FROM car_brand a left join car_base_info b on a.id=b.brand_id
WHERE b.is_deleted = 0
GROUP BY a.brand_name
ORDER BY a.create_time desc
676
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
