求sql語句解决办法

求sql語句
表
字段:           aa                 bb
                    001               张三
                    002               李四
                    001               王五
          求sql语句把aa字段中记录相同的显示出来?   即上述表中显示bb字段为张三及王五的记录出来.       谢谢


------解决方案--------------------

Select * From 表
Where aa In (Select aa From 表 Group By aa Having Count(aa) > 1)
------解决方案--------------------
SELECT * FROM AA IN (select aa from tb group by aa having count(*) > 1)
------解决方案--------------------
Select * From 表
Where aa In (Select aa From 表 Group By aa Having Count(aa) > 1)

------解决方案--------------------
SELECT * FROM tb where AA IN (select aa from tb group by aa having count(*) > 1)