怎么找出重复记录

[hljhl]

将一个现有的表的gh字段做主键，系统提示gh中有重复的值，我如何找到重复值是什么。 谢谢！

[zjcxc]

select gh from 表 group by gh having count(*)>1

[dlpseeyou]

select * from table gh in(select gh=sum(1) from table group by gh hvaing gh>1)

[dlpseeyou]

是不是要显示全部字段啊
select * from table
where gh in (select gh from table group by gh having sum(1)>1)

[donghb8]

受教,我好瓜,以前建临时表,5555555555555