执行以上SQL语句后,将会得到如下结果: 2、去重和排序:GROUP_CONCAT函数支持DISTINCT关键字去除重复值,以及ORDER BY子句对结果进行排序。 “`sql SELECT student_id, GROUP_CONCAT(DISTINCT score ORDER BY score DESC SEPARATOR ‘, ‘) AS scores FROM scores GROUP BY student_id; “` 动态SQL语句拼接所有列 1...