用sum需要和group结合使用
如:
Select reportDate,sum(reportBaoNum) as totalBaoSum From hosSubsidy_view Where reportDate >=? And reportDate<=? group by reportdate;
如:
Select reportDate,sum(reportBaoNum) as totalBaoSum From hosSubsidy_view Where reportDate >=? And reportDate<=? group by reportdate;
还可以求出某期段内的总数
Select sum(reportBaoNum) as totalBaoSum From hosSubsidy_view Where reportDate >=? And reportDate<=?;