ORACLE查询不同设备某一时间段内焊接工件数量，查询语句怎么写？

Question

表结构 
RN_DATA_ID   焊接ID,  RN_DATA_EQUIP_ID设备ID,RN_DATA_D537 工件焊接数量，RN_DATA_UP_TIME更新时间及数据格式（2016/12/20 星期二 下午 1:01:28）我想用语句查询出  20161201-20161220 这个时间段，焊接ID等于（1、2、3）设备的工件焊接总数。注：数据是每秒更新一条，实时更新。工件焊接数量实时累计，每天最后一条数据的工件焊接数量为当天的焊接数量，第二天0时工件焊接数量清零从新计数。请各位帮帮忙例如数据：
RN_DATA_ID       RN_DATA_EQUIP_ID        RN_DATA_D537                          RN_DATA_UP_TIME
          1                                  1                                         0                                2016/12/20 星期二 下午 1:01:29   
          2                                   2                                         2                               2016/12/20 星期二 下午 1:01:29   
          3                                    3                                        1                               2016/12/20 星期二 下午 1:01:29   
         4                                  1                                           1                               2016/12/20 星期二 下午 1:01:30   
          5                                   2                                         4                              2016/12/20 星期二 下午 1:01:30   
         6                                    3                                         3                              2016/12/20 星期二 下午 1:01:30   
          7                                  1                                          3                                2016/12/20 星期二 下午 1:01:31   
         8                                   2                                          6                              2016/12/20 星期二 下午 1:01:31   
         9                                   3                                          5                             2016/12/20 星期二 下午 1:01:31   
 

Answer 1

select RN_DATA_EQUIP_ID,sum(RN_DATA_D537)
from tab_name
where to_char(RN_DATA_UP_TIME,'yyyymmdd') between '20161201' and '20161220'
group by RN_DATA_EQUIP_ID;
很简单的语句啊？ 是要这样的？

Answer 2

不是的，一天一个ID可不止一条数据，数据是实时更新的，每秒一条，而且设备也不只三台设备。需要取ID IN (1，2，3)设备每天的最后一条数据之后，汇总焊接工件数量