SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE counties (
    name varchar(50)
);

INSERT INTO counties (name) VALUES 
('India'), 
('Pakistan'), 
('Australia'), 
('Srilanka');

4 rows affected

SELECT CONCAT(c1.name, ' vs ', c2.name) AS Combination
FROM counties c1
CROSS JOIN counties c2
WHERE c1.name < c2.name
ORDER BY Combination

Combination

Australia vs India

Australia vs Pakistan

Australia vs Srilanka

India vs Pakistan

India vs Srilanka

Pakistan vs Srilanka

SELECT CONCAT(c1.name, ' vs ', c2.name) AS Combination
FROM counties c1
CROSS JOIN counties c2
WHERE c1.name <> c2.name
ORDER BY Combination

Combination

Australia vs India

Australia vs Pakistan

Australia vs Srilanka

India vs Australia

India vs Pakistan

India vs Srilanka

Pakistan vs Australia

Pakistan vs India

Pakistan vs Srilanka

Srilanka vs Australia

Srilanka vs India

Srilanka vs Pakistan