Cricket Querry in sql
create table Cricket ( Country nvarchar(20) ) select * from Cricket insert into Cricket values ('India') insert into Cricket values ('Pakistan') insert into Cricket values ('Us') insert into Cricket values ('South Africa') select (A.Country +' VS '+B.country) As Matches from Cricket A inner join Cricket B on A.Country>b.Country