1.select d.id,d.outer_code from dict_depts_source d order by outer_code(查看重复数据) 2.select d.id,d.outer_code,row_number() over(partition by outer_code order by outer_code) row_flag from dict_depts_source d(标识重复数据) 3.delete from dict_depts_source where id in( 3.select d.id,d.outer_code,row_number() over(partition by outer_code order by outer_code) row_flag from dict_depts_source d(检查删除效果) |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11320622/viewspace-675648/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11320622/viewspace-675648/