sql语句紧急求救

[nuaawyd]

数据库表中有两个字段（A,B）
A为关键字，数据库中可能出现不同的A对应有相同的B，如果将这些记录找出来，拜托了！

[paoluo]

Select
A
From
TableName
Group By A
Having Count(*) >1

[paoluo]

錯了，

Select
B
From
TableName
Group By B
Having Count(*) > 1

[paoluo]

Create Table TEST(
A Int,
B Int)

Insert TEST Select 1, 2
Union All Select 2, 3
Union All Select 3, 2
Union All Select 4, 1
Union All Select 5, 1
GO
Select
B
From
TEST
Group By B
Having Count(*) > 1
GO
Drop Table TEST
/*
B
1
2
*/

[paoluo]

如果是得到所有重復的紀錄

Create Table TEST(
A Int,
B Int)

Insert TEST Select 1, 2
Union All Select 2, 3
Union All Select 3, 2
Union All Select 4, 1
Union All Select 5, 1
GO
Select
A.*
From
TEST A
Inner Join
TEST B
On A.A != B.A And A.B = B.B
Order By A.B, A.A
GO
Drop Table TEST
/*
A B
4 1
5 1
1 2
3 2
*/

[vwengineer]

SELECT A,B FROM ss
where a+b in(select a+b from ss group by a,b having count(*)>=2)

[nuaawyd]

四楼的取出来的重复的太多了
五楼的根本取不到数据

[paoluo]

修改下

Create Table TEST(
A Int,
B Int)

Insert TEST Select 1, 2
Union All Select 2, 3
Union All Select 3, 2
Union All Select 4, 1
Union All Select 5, 1
Union All Select 6, 1
GO
Select
Distinct
A.*
From
TEST A
Inner Join
TEST B
On A.A != B.A And A.B = B.B
Order By A.B, A.A
GO
Drop Table TEST
/*
A B
4 1
5 1
6 1
1 2
3 2
*/

[paoluo]

加上一個Distinct