你可以尝试使用 SUM 和 group by

You can try to use SUM with group by

SELECT ID,colA,ColB,SUM(ColuC) ColuC
FROM T
GROUP BY ID,colA,ColB