有谁知道如何从中找到那些重复的记录？？？

[pigwangrq]

我的数据表 product 中 productid 有些记录重复了！
如何把他们找出来？？？
大哥们帮忙呵！！！

[LBYYBL]

select productid from product group by productid having count(1)>1

[子陌红尘]

select * from product where productid in(select productid from product group by productid having count(*) > 1)

[colinliu]

select * from product where productid in (select productid from product group by productid having count(*) > 1)