在oracle数据库中,如何删除重复记录数据呢?
语句:
复制代码 代码示例:
--方法1
delete from t_insure_feed where user_id in (select user_id from t_insure_feed group by user_id having count(*)>1);
--方法2
delete from T_INSURE_FEED where rowid not in (select max(rowid) from T_INSURE_FEED group by user_id)