查询是否有重复数据:
select DEV_BRU_A(表的主键列) from u_hx_adm_sub_bureau(表名) group by DEV_BRU_A having count(DEV_BRU_A) > 1;
注:其中的‘DEV_BRU_A’是表的主键列,‘u_hx_adm_sub_bureau’为表名。
删除重复数据:
delete from u_hx_adm_sub_bureau where DEV_BRU_A in
(select DEV_BRU_A from u_hx_adm_sub_bureau group by DEV_BRU_A having count(DEV_BRU_A) > 1)
and rowid not in
(select min(rowid) from u_hx_adm_sub_bureau group by DEV_BRU_A having count(DEV_BRU_A) > 1);