查找表中的重复行

查找表中的重复行


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