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

[@briandennehy6380]

Best SQL channel on youtube for intermediate to advanced querying 👍

[@LearnatKnowstar]

Thank you so much!

[@joeanderson3423]

MOST Excellent. Clear and concise.

[@LearnatKnowstar]

Thank you

[@gangadharpandey3455]

wonderful explanation

[@LearnatKnowstar]

Thank you

[@hv0032113]

Very helpful. Thanks.

[@LearnatKnowstar]

Thank you

[@un_officialmcoc8218]

thank you

[@LearnatKnowstar]

Thank you

[@Faisal1504]

Thanks

[@LearnatKnowstar]

Thank you

[@Faisal1504]

Second parameter can be added to dense rank function also?

[@Faisal1504]

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

[@LearnatKnowstar]

Yes, you can order all functions by the columns that are needed to define a unique record.

[@vamshitha449]

Very useful but please maintain some clarity

[@gajalakshmisamayadurai]

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

[@pradeepba1439]

The output is of two tables or one table

[@LearnatKnowstar]

You can simply use Join between two instances of the same table ex - select * from country a join country b On a.team < b.team

[@LearnatKnowstar]

Thank you for posting this question. It is a good scenario and we will post a video tutorial as well in coming weeks for this scenario.

[@saisarandarbha3031]

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'; with country as ( select *, row_number() over (order by (select 1)) as r from @country) select a.country,b.country from country a join country b on a.countryb.country where a.r

[@Faisal1504]

Thanks.