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

preview_player
Показать описание
Short videos showing the difference in the RANK(), DENSE_RANK(), and ROW_NUMBER() ranking functions.
Рекомендации по теме
Комментарии
Автор

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

prajwaltawade
Автор

this is how every video on youtube should be like

mangolos
Автор

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

poonamvarkhedi
Автор

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

fernandasoares
Автор

excellent video. short and informative

supermami
Автор

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!

jerichaux
Автор

Finallyy!! someone explains this so clearly! <3

TheBaBaLand
Автор

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

mumk
Автор

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

mukeshpatil
Автор

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

NforNatalie
Автор

simple and straight to the point. Thank you!

sandeepkotha
Автор

To the point. Very well explained.. Thanks!

nitinpujari
Автор

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

Thank you !!!

adrianb
Автор

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

jpsama