查询表中某列字段有重复的纪录？

[jshecn]

今天突然遇到这个问题，不知道怎么写？请大家帮忙

[lsxaa]

select *
from 表 a
where (select count(*) from 表 where 某字段=a.某字段)>1

[phantomMan]

distinct:

select distinct columnname from tablename

[hsj20041004]

---你查一下字段重复的记录，然后再想办法（删除或修改）
select 字段,count(*) as 次数 from tablename group by 字段 having count(*)>1

[wangdehao]

select * from table where 字段 in (select 字段 from table group by 字段 having count(1)>1 )

or

select *
from table a
where (select count(*) from 表 where 字段=a.字段)>1

[hxq987]

学习

[wscft]

select distinct a.*
from table1 a, table1 b
where b.col1!= a.col1 and b.col2 = a.col2

[jshecn]

谢谢。

[jshecn]

不是找出不同的纪录，而是把某个字段重复的纪录给找出来