摘要:
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(select id from(select d.id,d.outer_code,row_nu 阅读全文