当然,请参见http://dev.mysql.com/doc/refman/...tions.html#function_group-
concat:
SELECt student_name, GROUP_CONCAt(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') FROM student GROUP BY student_name;

当然,请参见http://dev.mysql.com/doc/refman/...tions.html#function_group-
concat:
SELECt student_name, GROUP_CONCAt(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') FROM student GROUP BY student_name;