SQL Interview Question | Difference between Row Number, Rank and Dense Rank | Tie-breaking scenario

wonderful explanation

Can you add second parameter to row number and dense rank functions like you did to rank ?

Second parameter can be added to dense rank function also?

Thanks

Thanks.

🄿🅁🄾🄼🄾🅂🄼

MOST Excellent. Clear and concise.

Very useful but please maintain some clarity

How to solve this problem

declare @Country as table (country varchar(20))

insert into @Country select 'INDIA'
insert into @Country select 'AUS'
insert into @Country select 'Srilanka'
insert into @Country select 'England'
insert into @Country select 'South Africa'

-- Input
select * from @Country

-- Required Output with single select statement
Team_A Team B
INDIA AUS
INDIA Srilanka
INDIA England
INDIA South Africa
AUS Srilanka
AUS England
AUS South Africa
Srilanka England
Srilanka South Africa
England South Africa

Very helpful. Thanks.

thank you