方案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);