重复记录的处理

方案1

delete from temp_zhangxb_2015110501a a where a.cust_id in (select a.cust_id from temp_zhangxb_2015110501a a group by a.cust_id having count(cust_id) > 1) and rowid not in (select min(rowid) from temp_zhangxb_2015110501a b group by b.cust_id having count(cust_id) > 1); 

方案2

delete from temp_zhangxb_2015110501a a where rowid not in (select min(rowid) from temp_zhangxb_2015110501a b where a.cust_id = b.cust_id);