查找表中的重复行

查找表中的重复行

select * from tb_producttype where protname in( 

select protname from tb_producttype group by protname having count(*)>1 

)