用sum函数加group by配合就可以达到你的要求了，例如这样，select sum(num) from table group by time，希望对你有帮助
SELECT PRD_TIME, SUM(PLA_Num) AS PLA_Num, SUM(REL_Num) AS REL_Num, SUM(DEF_Num) AS DEF_NumFROM [表名字]GROUP BY PRD_Time
