查找表中的重複行

查找表中的重複行

select * from tb_producttype where protname in( 

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

)