select b.UserID,b.ClassID,c.SchoolID ,c.UserName,max(b.Score) maxScore, GROUP_CONCAT(b.Score SEPARATOR '-') groupScore from(select a.UserID,a.SchoolID,a.ClassID,a.UserName,a.Score from contest_table_35 a where a.ClassID=294087 and a.SchoolID=305725 limit 1,10) c Inner JOIN contest_table_35 b on b.UserID=c.UserID Group by b.UserID ORDER BY maxScore 有人解答么?
select b.UserID,b.ClassID,c.SchoolID
,c.UserName,max(b.Score) maxScore,
GROUP_CONCAT(b.Score SEPARATOR '-') groupScore
from(select a.UserID,a.SchoolID,a.ClassID,a.UserName,a.Score
from contest_table_35 a where a.ClassID=294087
and a.SchoolID=305725 limit 1,10)
c Inner JOIN contest_table_35 b on b.UserID=c.UserID
Group by b.UserID
ORDER BY maxScore 有人解答么?