查看哪些字段重复和重复几次
select dwmc,count(*) as c from table_dw group by dwmc having c>1
显示重复字段的所有信息
select *from table_dw where dwmc in (select dwmc from table_dw group by dwmc having count(dwmc)>1)