SELECT
DISTINCT bq.BUILDING_NO,
sum(a.SCORE) over(partition by bq.BUILDING_NO)AS scores,
bacn.TYPE,
bq.PROJECT_ID
FROM
BQ2_INSPECT_CHECK a
INNER JOIN BQ2_ASSESS_CRITERIA bac ON bac.ID = a.CRITERIA_ID
INNER JOIN BQ2_ASSESS_CRITERIA_NODE bacn ON bac.CRITERIA_NODE = bacn.ID
INNER JOIN BQ_QUESTION bq ON bq.ID = a.QUESTION_ID
WHERE
1 = 1
AND bq.del_flag = 0
and bacn.Type = 'E'
sum(a.SCORE) over(partition by bq.BUILDING_NO)AS scores,a.Score为需要统计的字段,bq.BUILDING_NO为分组的字段,同时查询bq.BUILDING_NO字段时,需要在前面加DISTINCT ,不然数据会重复。