Loading

How to fetch below output using SQL query?

How to fetch below output using SQL query?

Md Saud Alam

Md Saud Alam

8y813

Team:

1 India

2 Pakistan

3 Srilanka

4 Australia

Output:

1 Pakistan VS India

2 Srilanka VS Pakistan

3 Srilanka VS India

4 Australia VS Srilanka

5 Australia VS Pakistan

6 Australia VS India

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shahriar Nikkhah8y ago
Accepted answer
GOOD LUCK
DECLARE @tblXYZ AS TABLE
(   [id]        Int
,   [Team]      nVarChar(100)
)

INSERT INTO @tblXYZ
VALUES (1,'India') , (2,'Pakistan') , (3, 'Srilanka ') , (4,'Australia')

--- For Test
SELECT  [ROW] =  ROW_NUMBER() OVER(ORDER BY MT.Team ASC)
    ,   [Play] = MT.Team + ' vs ' + ST.Team
FROM    @tblXYZ MT
INNER JOIN @tblXYZ ST ON MT.Team <> ST.Team AND MT.id > ST.id
ORDER BY 1 ASC , st.id DESC
+1
Shahriar Nikkhah8y ago
Thank you for the nice question
0
Md Saud Alam8y ago
Thanks Sir
0