查询表中某列相同的记录选出来?

[JerryOne]

表T1(A varchar(20),B varchar(40))
(1,F1)
(1,F11)
(1,F111)
(2,F2)
(2,F22)
(3,F3)
(4,F4)

变成
(1,F1)
(1,F11)
(1,F111)
(2,F2)
(2,F22)
请问怎么实现？

[internetcsdn]

select distinct * from 表

[internetcsdn]

看错

[internetcsdn]

create table t1 (a varchar(10),b varchar(10))
insert t1
select '10','100'
union all select '10','200'
union all select '20','300'
union all select '20','400'
union all select '30','500'

select * from t1 where a in(
select a from(
select a,count(a) as cou from t1
group by a)aa
where cou>=2)

[jjg0020]

select * from table
group by A having count(A)>=2

[internetcsdn]

参照:： jjg0020(jjg0020)

create table t1 (a varchar(10),b varchar(10))
insert t1
select '10','100'
union all select '10','200'
union all select '20','300'
union all select '20','400'
union all select '30','500'

select * from t1 where a in(select a from t1
group by A having count(A)>=2)

[gechaosa]

select * from t1 where a in (select a from t1
group by A having count(A)>=2)

[jinsfree]

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