求sql語句表字段:aabb001张三002李四001王五求sql语句把aa字段中记录相同的显示出来?即上述表中显示bb字段
求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)