Quick! What's the difference between RANK, DENSE_RANK, and ROW_NUMBER? 

Short and simple.Thanks for saving my time. I have my interview tomorrow.

this is how every video on youtube should be like

Only video that helped me. Thank you!

Come back to this video every time I need a recap. Quick and with easy to follow examples. Thank you!

this is such a GREAT video!! so simple and straight-forward

Finallyy!! someone explains this so clearly!

excellent video. short and informative

Doug: you are AWESOME! I really quite appreciate the brevity (not that there's anything wrong with your longer videos, those are FANTASTIC as well!) in comparison to the typical SQL videos, which are more on the order of 30-90 minutes, and are hardly digestible. Keep up the outstanding content!

holy shit this is such a clear and concise explanation in 2 minutes! you are awesome!

Easy to understand, with examples and comparisons, agree that this is how every video should be made. Thanks Doug.

I’m subscribing. This video taught better than Dataquest 😂

simple and straight to the point. Thank you!

To the point. Very well explained.. Thanks!

Thank you, Doug.

well done, great job!

Thanks Doug

amazing explanation , thank you!

Thank you, this is amazing! Great quality content! Now i finnally understand!!! Thank you !!!

Thanks for being clear and brief!!

Quick and informative, thanks.

That’s what I’m talking about Doug

i love you, doug

on point!

Thanks man thanks. Good. Thank you. Good luck

This is amazing

ty

If partioned by some column say like dept row number Nd rank would give same result right

Great explanation. Thank you!