oracle删除重复数据

 

select  id from LOG
  where created >= to_date('2015/2/7 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
  and created <= to_date('2015/2/8 18:00:00', 'yyyy-mm-dd hh24:mi:ss')
group by id
having count(*) > 1

 

delete from LOG
where id in (SELECT id FROM LOG 
GROUP BY id HAVING COUNT(id) > 1)
AND ROWID NOT IN (SELECT MIN(ROWID) FROM BJ_SDK_LOG_PAY GROUP BY id HAVING COUNT(*) > 1);