Microsoft SQL Server 查询表中有重复列值的数据 (PARENTGOODSID列值重复的行)？

select * from tb where PARENTGOODSID in(select PARENTGOODSID from tb group by PARENTGOODSID having count(1)>1)