请教各位如何列出重复的记录

[BabySky716]

比如表A有字段aa bb cc
如何查询bb重复的记录？？
Distinct只能删除重复，我要查询重复的！

[lsqkeke]

select * from tablename where count(bb)>1

[lsqkeke]

我写错了 ：（

[lw1a2]

select *
from A t
where (select count(1) from A where bb=t.bb)>1

[lsqkeke]

select * from tb ,(select bb,a=count(bb) from tb group by bb)b
where tb.bb=b.bb and b.a>1

[lsqkeke]

select tb.* from tb ,(select bb,a=count(bb) from tb group by bb)b
where tb.bb=b.bb and b.a>1

[yitangliang]

select * from A where bb in (select bb from A group by bb having count(*)>1)