MySQL支持实现group_concat() 内部自定义排序:
实例:
新建一张表 reward,表中数据如下:
SQL:
SELECT uid, GROUP_CONCAT(money ORDER by money DESC) AS money_desc FROM reward GROUP BY uid DESC;
使用其他字段也一样的效果:
SQL:
SELECT uid, GROUP_CONCAT(id ORDER by money DESC) AS id_money_desc FROM reward GROUP BY uid DESC;
Original: https://www.cnblogs.com/woods1815/p/16213777.html
Author: 幽篁晓筑
Title: MySQL实现 group_concat 排序
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/606882/
转载文章受原作者版权保护。转载请注明原作者出处!