通过PersonID获取每个人的总和 [英] get the SUM of each Person by the PersonID

问题描述

我在表格中有以下几列:

I have the following columns in a table:

SCORE_ID 
SCORE_PERSON_ID 
SCORE_VOTE

SCORE_PERSON_ID是变量.我需要对每个SCORE_PERSON_ID的SCORE_VOTE求和.

The SCORE_PERSON_ID is a variable. I need to sum the SCORE_VOTE per SCORE_PERSON_ID.

您能建议一个好的方法吗?

Can you suggest of a good way to do that?

推荐答案

您需要GROUP BY和诸如count或sum

SELECT SCORE_PERSON_ID, sum(SCORE_VOTE) as score
FROM table 
GROUP BY `SCORE_PERSON_ID`

这篇关于通过PersonID获取每个人的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！