可以这样写:. SELECT username,GROUP_CONCAT(score ORDER BY score DESC) AS myScore FROM t1 GROUP BY username;. 效果如下:.
確定! 回上一頁