1、字段列对应重复记录数据的查询sql,简单就是取出某个字段多个重复值分组数量
select supplier_name ,count(*) from MO_FROM_SYS.SUPPLIER group by order_code having count(*) > 1;
2、删除表字段中重复记录数的sql语句(ID为当前表的主键值,usage_category_name为具体字段)
delete from MO_FORM_V8.UNS_HOUSE_GOODS where usage_category_name in
( select usage_category_name from MO_FORM_V8.UNS_HOUSE_GOODS group by usage_category_name having count(*) > 1 ) and id not in
( select min(id) from MO_FORM_V8.UNS_HOUSE_GOODS group by usage_category_name);