简单查询问题（100分）
表中只有A字段
数据如下
      A
      XXXX
      XXXX
      YYYY
      YYYY
      DDDD

我想得到前4条语句，也就是如果A字段中有相同的记录就选出来。
DDDD只有一条，就不选他。

谢谢大家，在线百分答谢


------解决方案--------------------
select * from [Table] where a in(
select a from [Table] group by a having count(1)> 1)
------解决方案--------------------
select
a.*
from
tName a,
(select A,count(*) as cnt from tName group by A) b
where
a.A=b.A and b.cnt> 1
------解决方案--------------------
select * from [Table] a where (select count(1) from [Table] where a=a.a)> 1
------解决方案--------------------
declare @a table(a varchar(10))
insert into @a
select 'XXXX ' union all select 'XXXX '
union all select 'YYYY '
union all select 'YYYY '
union all select 'DDDD '

select * from @a where a in(select a from @a group by a having count(*) > 1)


结果
a
----------
XXXX
XXXX
YYYY
YYYY
------解决方案--------------------
select * from A
where id in (select a ,count(*) from A group by a having count(*)> 1)