How to get the below result.?

Question

question

ranjanjena17 asked Jun 4, '20

How to get the below result.?

I have table called : Tab1 , having column col1

Col1

A

B

C

D

Need a generic query to fetch below result

AB

AC

AD

BC

BD

CD

sql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-06-04T08:32:56Z

Kev Riley answered Jun 4, '20

declare @Tab1 table (col1 char(1))
insert into @Tab1 (col1)
values ('A'),('B'),('C'),('D')


select Tab1_1.col1 + Tab1_2.col1
from @Tab1 Tab1_1
join @Tab1 Tab1_2 on Tab1_2.col1 > Tab1_1.col1
order by Tab1_1.col1

----
AB
AC
AD
BC
BD
CD

(6 rows affected)

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jeff Moden commented · Jun 28, 2020 at 06:39 PM

As a bit of a sidebar, this is a classic example of an "Exclusive Triangular Join".

0 ·

question