1.记录去重
delete from tlbb.tlbb_bind_log
where rowid not in (select max(rowid)
from tlbb.tlbb_bind_log
where BUY_TIME >= to_date('2012-07-10', 'yyyy-mm-dd')
and BUY_TIME < to_date('2012-07-12', 'yyyy-mm-dd')
group by sn)
and BUY_TIME >= to_date('2012-07-10', 'yyyy-mm-dd')
and BUY_TIME < to_date('2012-07-12', 'yyyy-mm-dd');