原来GROUP_CONCAT中,是支持GROUP内排序的
SELECT student_name,
GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ')
FROM student
GROUP BY student_name;
原来GROUP_CONCAT中,是支持GROUP内排序的
SELECT student_name,
GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ')
FROM student
GROUP BY student_name;
1866

被折叠的 条评论
为什么被折叠?