当然,请参见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;
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)