求一条SQL语句，请大家帮忙

[snowouldance]

有一张表，其中有字段A1，B1
A1不会有重复列，B1有重复列

例如
A1 B1
----------------
A AA1
B AA2
C AA2
D AA3

想写一条SQL语句，把所有B1字段重复的记录都选出来
结果
B AA2
C AA2

[AcHerat]

select *
from tb t
where exists (select 1 from tb where B1 = t.B1 and A1 <> t.A1)

[AcHerat]

select *
from tb
where B1 in (select distinct B1 from tb group by B1 having count(0) > 1)

[AcHerat]

select *
from tb t
where 1 < (select count(*) from tb where B1 = t.B1)

-- try !

[--小F--]

select * from tb t where exists (select 1 from tb where B1 = t.B1 and A1 <> t.A1)

[cd731107]

select * from tb t where exists (select 1 from tb where B1 = t.B1 and A1 <> t.A1)

--或者
select * from tb where B1 in (select B1 from tb group by B1 having count(B1)>1)