–删除重复数据只留一条

delete from t_kpi_province_m
 where id not in (select max(id) from t_kpi_province_m t group by t.指标)

–删除重复数据

delete from t_kpi_province_m
 where id not in
       (select (id)
          from (select max(id) as id, t.城市, t.类型, t.日期, t.指标
                  from t_kpi_city_d t
                 where to_char(t.日期, \'yyyy-mm-dd\') = \'2012-09-10\'
                 group by t.城市, t.类型, t.日期, t.指标
                 order by t.指标))

–删除重复数据取小时删除

select *
  from t_kpi_city_d t
 where t.指标 = \'GSM半速率比例(本月)\'
   and to_char(t.日期, \'yyyy-mm-dd\') = \'2012-09-10\'
   and to_char(t.创建日期, \'hh24\') = \'11\';

 

 

 

版权声明：本文为rafx原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/rafx/archive/2012/09/11/2680081.html