查找表中的重复行
select * from tb_producttype where protname in(
select protname from tb_producttype group by protname having count(*)>1
)
select * from tb_producttype where protname in(
select protname from tb_producttype group by protname having count(*)>1
)