mysql - 带求和函数的 GROUP CONCAT

Question

我想连接我的 sum 函数的总和，请帮助我，谢谢这是我的查询:

SELECT t1.province, t2.fullname,sum(t1.total_vote) AS total
FROM votes AS t1, candidate AS t2
WHERE t1.candidate_id = t2.id
GROUP BY t2.id, t1.province
ORDER BY t2.id

Answer 1

所以只需使用concat即可。 (内部联接会更简洁。)

SELECT concat(t2.fullname, ' has ', sum(t1.total_vote), ' votes in ', t1.province, '.') AS concatinated_line
FROM votes AS t1
INNER JOIN candidate AS t2 ON t1.candidate_id = t2.id
GROUP BY t2.id, t1.province
ORDER BY t2.id