怎么写语句查出一列中重复的记录

[nirvana_boy]

例如
A
B
C
C
D
D
怎么写可以查出
C
C
D
D

[w_jie]

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

[pengdali]

select * from 表 where 列 in (select 列 from 表 group by 列 having count(*)>1)

[huzx]

mark