Getting unique combination of rows in SQL??

[Lima3]

I have a requirement as in below

DECLARE @TEST TABLE (X VARCHAR(10),Y VARCHAR(10))

insert into @TEST values ('A','B'),('C','D'),('E','F'),('B','A'),('D','C'),('F','E')

SELECT A.* FROM @TEST A, @TEST B WHERE A.X = B.y gives X Y A B C D E F B A D C F E But I have to get only the combination (AB or BA) ,(CD or DC),(EF or FE) in my select statement. In my sql we have some thing called DistinctRow.. What is it in SQL ..Pelase help ..urgent..

[AHSAN111]

Try using the Distinct Keyword

SELECT Distinct(A.x), A.Y FROM @TEST A, @TEST B WHERE A.X = B.y

[Blue_Boy]

here it is

DECLARE @TEST TABLE (X VARCHAR(10),Y VARCHAR(10))

insert into @TEST values ('A','B')
insert into @TEST values ('C','D')
insert into @TEST values ('E','F')
insert into @TEST values ('B','A')
insert into @TEST values ('D','C')
insert into @TEST values ('F','E')

SELECT A.X
,(
select top 1 b.y from @test as b where b.y > a.x and b.x a.x and b.x

---

I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.

[Lima3]

Excellent .. thanks for the reply..

[Lima3]

I was looking for some key word like distinctrow in MYSQL.. dont we have any thing like that in SQL.

[Lima3]

Finally SELECT X,Y FROM @TEST WHERE X

[Blue_Boy]

There exists DISTINCT option to retrieve non-repeated values, but your case was different from using DISTINCT. Glad to help you.

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.