sql 中添加sum函数

1 files changed, 2 insertions, 2 deletions

diff --git a/src/main/resources/mybatis/mapper/MonitorMapper.xml b/src/main/resources/mybatis/mapper/MonitorMapper.xml
index 0fe6b16..0335236 100644
--- a/src/main/resources/mybatis/mapper/MonitorMapper.xml
+++ b/src/main/resources/mybatis/mapper/MonitorMapper.xml
@@ -31,13 +31,13 @@
 
     <select id="getNetWaterMonitor" resultType="com.nis.galaxy.domain.NetWaterMonitor">
         <![CDATA[
-        SELECT entrance_id AS area,'OUT' AS type,ifnull(s2c_byte_len,0) AS count,#{push} AS time
+        SELECT entrance_id AS area,'OUT' AS type,ifnull(sum(s2c_byte_len),0) AS count,#{push} AS time
         FROM traffic_trans_statistic
         where stat_time >= #{start}
             and stat_time < #{end}
         group by area
 	    UNION ALL
-        SELECT entrance_id AS area,'IN' AS type,ifnull(c2s_byte_len,0) AS count,#{push} AS time
+        SELECT entrance_id AS area,'IN' AS type,ifnull(sum(c2s_byte_len),0) AS count,#{push} AS time
         FROM traffic_trans_statistic
         where stat_time >= #{start}
             and stat_time < #{end}