更新时间:2022-02-21 09:04:42
使用 Group_Concat 函数
SELECT team, SUM(points) AS totals,group_concat(driver) FROM `example-table` GROUP BY team ORDER BY `points` DESC
SQL选择并按另一列分组后显示一列的所有值