SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?

[@dnfvideo]

Do not miss our Interview Question video series 30 Important C# Interview Questions : kzbin.info/www/bejne/eHzcn3h4hdacf68 25 Important ASP.NET Interview Questions : kzbin.info/www/bejne/ponQfpejf7p2Zsk 25 Angular Interview Questions : kzbin.info/www/bejne/Y5vIoKx6f6mmia8 5 MSBI Interview Questions : kzbin.info/www/bejne/a3abYmiXjaaqj7M

[@rohitekka2674]

Old is gold. no matter which site I searched or how many times I read through in understanding these concepts. You managed to explain all of it in matter of 10 minutes. Awesome stuff !!! Hope you keep making videos like this.

[@SumanDas-df5df]

Tough competition between Venkat (Kudvenkat) and Shiv (Questpond). Both are superb.

[@ARJUN-op2dh]

Made in 2012, helping in 2021 as well... Thank you !

[@RohanRamVaswani]

2021

[@arkapoddar3727]

Agreed

[@vrindavaneshwari_ju_ki_kripa]

abe ha bhai 2022 me b

[@rahulmittal116]

Want to learn SQL from scratch - Subscribe to kzbin.info/door/-yCdYQYwNy7ZVzQ9FfAgqA and start with 1st video. SQL Joins video - kzbin.info/www/bejne/oHrRoWqLrpp3m6c SQL tutorial is here for you

[@biplabbaishnab3926]

In 2022 as well

[@itscmg]

The best and simplest example for all these functions. Been a long time I used rank function, great for brushing up :) Thank you!

[@CreatingUtopia]

Knowing something , explaining something both are polar opposite talents, and you sir have mastery on both. Thank you so much for the clear explanation.

[@lahari_explorer]

Made in 2012 helping forever 💖 Watching this video for my upcoming interview 😊🐕😙

[@pranavbhat92]

Helped me in 2023 December! Thank you so much for this amazing teacher. 🙏

[@noronhasanjay]

A gentleman who is both technical and philosophical. Thank you sir.

[@SumanDas-df5df]

He is Shiv Koirala

[@ni12907]

WOWOWOOW This is the best tutorial for Rank Dense rank, row number partition by !!! super helpful, thank you!!! 👌👌👌👌👌👌

[@krithikakumaragurubaran7110]

Simplest but most effective.. one of the best videos for learning

[@yuvrajpardeshi1429]

Best and Simplest video ever on rank, partition, row_number and something new i learnt the dense_rank. Keep up the great work ! you are awesome

[@aakankshasrivastava7996]

How beautifully and with an ease he has taught.... Thankyou sir🙏🏻

[@GabrielPosternak]

Excellent, until now I didn't understand what is over() for, but now is very clear.

[@88spaces]

Good explanations of these functions. I don't always remember their meanings so it is nice to have a video like yours as a reminder. Thank you.

[@subtlehustle6300]

To this content maker, thank you a lot for explaining this in the most simplest way. I had a real hard time to understand the simple concept of Row_number. Thanks again.

[@SumanDas-df5df]

Just remember his name : Shivprasad Koirala

[@raveenachakrapani1090]

Very helpful video. Explained the concepts in 10 mins

[@theunusual4566]

2023, but still the best video to understand these topics. Thanks a lot Sir.

[@pankajjasrotia4178]

A simple and crystal clear explation , very good job done ..thanks a lot..

[@shwetabudake6144]

Awesome, very clear explanation within 10min.

[@ayandey15]

U simply taught a complex function. Thank u

[@renobramantyo5069]

Not all heroes wear capes, and you are one of them! thank you so much

[@rozario1309]

Thanks, Good Video. If we want to explain in one liners - Row_numbers generate IDs; Rank Generates Rank and skips subsequent ranks if the same rank is assigned for multiple rows; a dense_rank make sure ranks are not skipped. is that right?

[@Anubis10110]

I really appreciate your effort, Thank you so much. I was always confused about using Rank and Partition, most of the examples online are complex Thanks again

[@ankitasurjushe9150]

I love how Archies was big thing in 2012 and now it's just something we use to know! 😅🤷🏻‍♀️ In contrast to this video though.. it's still imp 🥺. Thanks for the video !

[@mayurpawar411]

excellent.... i m reading this in 2020.

[@ananth889]

Excellent video, it would be great if some more videos on other topics are done

[@nitinyog]

Superior Tutorial. Helpful and Understandable .

[@take_the_trade]

This is simply great explanation with practical

[@benyams8014]

simple and clear ...................that is all we need thankyou

[@krantikumar894]

Really njoyed and easily understand the concept tq sir

[@ilyasmohamed8231]

voice is v clr n explained v wel. thnk

[@iemranee]

Very well explained. You are an awesome teacher

[@sapien4]

Superb, you can describe hard things simply. Thank you Shiv

[@MaheshBabu1989]

Thanks for detailed explanation.. Can you clarify below question please.. My output for row_number function is below Select row_number() over(partition by record_no order by record_no) R_num,record_no,record_type R_num,record_no,recored_type 1, 767,105 1,564,106 2,564,107 1,887,108 2,887,105 3,887,103 1,662,104 1,880,106 If I want to retrieve only record_num having count >1.Then what should be the query My expected output should be like below 1,564,106 2,564,107 1,887,108 2,887,105 3,887,103

[@maheshbabunadigoti7050]

Awesome explanation sir....Very useful for us....great sir

[@mandarTube]

Very useful tips.. good that u combined the demonstration.

[@mohammadmamun5193]

Very clear and simple explanation.Thank you!

[@nssramya8792]

superb sir. I have one doubt how to partition the row_number by alphabetical order sir

[@gunupatihymavathi6114]

hi sir you are explained very well compare with others lectures

[@piyalichatterjee1532]

Very nice explanation, thank you for this video

[@MatteoPratesi]

Awesome, it's very clear!! Thank you very much!!

[@arandomchannel56]

You are a God for explaining this. Thank you, liked and subscribed!

[@chaitanya2725]

Great Explanation

[@anawadtom6011]

Good clear explanation. Thanks!

[@ramanujkumar9991]

Great explained sir,i was looking this only

[@vamsikonidla6912]

Super explanation.

[@kedardatar9259]

Enjoyed explanation. I understand concept quickly

[@jk787]

Very good example. My doubt is very clear about rank() dense_rank().

[@LukeArthurBates]

Great video - explaining a few closely related functions with practical applications and beginner level clarity. Thanks

[@beinghuman77733]

Very Good Explanation

[@Rahulkumar-ni8oh]

Very good explanation...

[@satishnagotkar886]

wonderful explanation Sir - Explain RowNumber,Partition,Rank and DenseRank ? keep it up it helps a lot specially for reports

[@akashsharma9210]

Great videooo this used to confuse me alot but now easy pezyyy!!!

[@rajdhanibeats4060]

Great explanation. Thank you

[@omarsilwadi7194]

Outstanding explanation of Row_number(), thank yo so much! Much appreciated!

[@Android.26]

I agree.. I also appreciate his detailed explanation and live example for Rank and Dense_Rank. I used to wrestle with skipped rsnking numbers and this answered howcto get consecutive rsnks without skipping numbers.

[@vanajag2576]

Awesome explanation sir thank so much sir

[@devashishghosh7497]

Row number is used to give sequential integral number to every row (starting with 1)

[@sureshsunkara4396]

Thank u so much..no one gives this much simple explanation as like u..u rockssss...

[@olgab3290]

Very well! Very clear, easy to understand.

[@nasrealam5496]

A very comprehensive video.. Kudos !

[@nabeelusmani5937]

Very well explained 🔥

[@namratanikam7566]

Very well explained😊

[@mohammedaasem1574]

This is what I was looking for 👍 Very useful

[@idontdotravelhoney]

What a neat explanation!!👍👍

[@jinyang4796]

Very neatly explained! Thank you so much! :D

[@shubhambansla3824]

Very well explained... One of the best explanation. Thanks

[@prasunjeetsoni6143]

I learnt new things ... thanks mentor

[@shafiaaskari5949]

Loved it. Thank you for making this 👏🏻

[@lalaniwerake881]

Nice video.. very helpful - Thanks

[@parmeshwarlahole1365]

Thanks alot your video is really helpful to us short and sweet and clear concept #thanks #keep doing #i liked # i shared & #subscribed also ....

[@babzo1]

Shivprasad on the move ..Thanks man for this tutorial.

[@EconomiKally]

Awesome explanation. You are a blessed teacher.

[@muraliraj9658]

wonderful Explanation sir..simply superb.

[@Faisal1504]

Can you use row number + partition to get the same result as rank and dense rank.

[@schaumaul]

this guy is a legend.

[@indranil-singercomposer]

You have explained it very lucidly..Thanks!

[@sachinraut1766]

Very well explained

[@thebluehurricane]

Very clear and easy to follow, thanks.

[@kalaivanan.s5042]

Simply awesome bro

[@dariom5073]

Excelent! the best explanation. Thanks!

[@primisole123]

Very good explanation!! Thank you :)

[@akgaab]

It was pretty useful.. thanks

[@RameshKumar-ng3nf]

Excellent Sir ! What a clear and detailed explanation . The best info in youtube for me. You made it very simple. Rest all youtube tutorials on this same topic were very confusioning and complex. Subscribed your channel. :-)

[@poojanagaramunnolli]

Well explained. Understood clearly.Thank you

[@shubhangikumar6265]

Great, well explained !! Thanks

[@rahulchugh6694]

very clear and helpfull ..!! great sir please upload more

[@vamsikonidla6912]

Super explanation

[@orshukrun]

Well explained. Thank you :)

[@himanshu7103]

how dense rank is different from partitioned , i mean if you apply partition on customer name it work as same as dense rank

[@priyasingh9984]

very well explained. short and best

[@syedmunazzirahmed3191]

Is there any difference between partition by and rank function? They both look to do the same. Correct me if I'm wrong.

[@ApoorvNaramdeo]

Syed Munazzir Ahmed , I think, Partition By is used, when we want to number/serialize the records having a common attribute/ group {in the above example, Vendor Name}. Rank and Dense_Rank are used when we want to give an attribute/ group a unique number {in the above case, CustomerName}. Does this help you?

[@amitghorpade6128]

Even I felt the same at beginning but observe carefully they are different.

[@gokukanishka]

good explanation

[@61percentodicarica]

6:35 I wasn't expecting to get some philosophy while watching a video to better understand why a collegue wrote a query this way.

[@sarahrachel143]

Thank u It was very helpful

[@manikyakalyan2228]

This is very useful information. Thank you

[@dkrishnaja]

Very useful 👍

[@rishabhsharma329]

This is phenomenal !

[@jras1996]

It is very clear!!! Thank you 🙏

[@anish_k]

thanks a lot mate, very informative & helpful as well..

[@ladhkay]

nice work mate!