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

[@dnfvideo]

Do not miss our Interview Question video series
30 Important C# Interview Questions : ua-cam.com/video/BKynEBPqiIM/v-deo.html
25 Important ASP.NET Interview Questions : ua-cam.com/video/pXmMdmJUC0g/v-deo.html
25 Angular Interview Questions : ua-cam.com/video/-jeoyDJDsSM/v-deo.html
5 MSBI Interview Questions : ua-cam.com/video/5E815aXAwYQ/v-deo.html

[@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 ua-cam.com/channels/-yCdYQYwNy7ZVzQ9FfAgqA.html
and start with 1st video.
SQL Joins video - ua-cam.com/video/jInp7Uy5DeE/v-deo.html
SQL tutorial is here for you

[@biplabbaishnab3926]

In 2022 as well

[@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.

[@itscmg]

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

[@lahari_explorer]

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

[@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.

[@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

[@nitinyog]

Superior Tutorial. Helpful and Understandable .

[@pankajjasrotia4178]

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

[@pranavbhat92]

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

[@MatteoPratesi]

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

[@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

[@raveenachakrapani1090]

Very helpful video. Explained the concepts in 10 mins

[@shwetabudake6144]

Awesome, very clear explanation within 10min.

[@aakankshasrivastava7996]

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

[@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.

[@benyams8014]

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

[@krantikumar894]

Really njoyed and easily understand the concept tq sir

[@renobramantyo5069]

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

[@chaitanya2725]

Great Explanation

[@maheshbabunadigoti7050]

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

[@GabrielPosternak]

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

[@ayandey15]

U simply taught a complex function. Thank u

[@mayurpawar411]

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

[@sapien4]

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

[@take_the_trade]

This is simply great explanation with practical

[@noronhasanjay]

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

[@SumanDas-df5df]

He is Shiv Koirala

[@shafiaaskari5949]

Loved it. Thank you for making this 👏🏻

[@vamsikonidla6912]

Super explanation.

[@arandomchannel56]

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

[@sureshsunkara4396]

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

[@nabeelusmani5937]

Very well explained 🔥

[@ilyasmohamed8231]

voice is v clr n explained v wel. thnk

[@anawadtom6011]

Good clear explanation. Thanks!

[@idontdotravelhoney]

What a neat explanation!!👍👍

[@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

[@nasrealam5496]

A very comprehensive video.. Kudos !

[@olgab3290]

Very well! Very clear, easy to understand.

[@mohammadmamun5193]

Very clear and simple explanation.Thank you!

[@namratanikam7566]

Very well explained😊

[@ramanujkumar9991]

Great explained sir,i was looking this only

[@rishabhsharma329]

This is phenomenal !

[@iemranee]

Very well explained. You are an awesome teacher

[@piyalichatterjee1532]

Very nice explanation, thank you for this video

[@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

[@dariom5073]

Excelent! the best explanation. Thanks!

[@rajdhanibeats4060]

Great explanation. Thank you

[@mohammedaasem1574]

This is what I was looking for 👍 Very useful

[@sakshikabra156]

Great video as always!

[@jinyang4796]

Very neatly explained! Thank you so much! :D

[@mandarTube]

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

[@akshayaseetharaman5687]

Very clear👍Thankyou!

[@ananth889]

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

[@Efficientfall]

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

[@Rahulkumar-ni8oh]

Very good explanation...

[@ladhkay]

nice work mate!

[@beinghuman77733]

Very Good Explanation

[@lalaniwerake881]

Nice video.. very helpful - Thanks

[@kalaivanan.s5042]

Simply awesome bro

[@shubhangikumar6265]

Great, well explained !! Thanks

[@shubhambansla3824]

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

[@kedardatar9259]

Enjoyed explanation.
I understand concept quickly

[@prasunjeetsoni6143]

I learnt new things ... thanks mentor

[@vanajag2576]

Awesome explanation sir thank so much sir

[@primisole123]

Very good explanation!! Thank you :)

[@babzo1]

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

[@schaumaul]

this guy is a legend.

[@muraliraj9658]

wonderful Explanation sir..simply superb.

[@Varghese_B]

Awesome ❤️

[@dkrishnaja]

Very useful 👍

[@ManjunathTondihal20]

Well explained. Understood clearly.Thank you

[@naveenshindhe2893]

Thanks for all the videos, it is great

[@jras1996]

It is very clear!!! Thank you 🙏

[@gunupatihymavathi6114]

hi sir you are explained very well compare with others lectures

[@anish_k]

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

[@EconomiKally]

Awesome explanation. You are a blessed teacher.

[@thebluehurricane]

Very clear and easy to follow, thanks.

[@eliabreu123]

This is great info!

[@orshukrun]

Well explained. Thank you :)

[@amirkazi1350]

Great video.

[@Life-d5k8g]

Simply clear

[@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 ....

[@osamanaeem3444]

amazing video. really clearly laid out!

[@akgaab]

It was pretty useful.. thanks

[@LukeArthurBates]

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

[@vamsikonidla6912]

Super explanation

[@indranil-singercomposer]

You have explained it very lucidly..Thanks!

[@Somu_Murugan]

Very well explained !! Thanks a lot !!

[@rahulchugh6694]

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

[@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.

[@swethanaidu4162]

Thanks. Nice Explanation !!!

[@keshavachandu99]

Really cool👍

[@agustinumulhasanah3073]

thankyou, really helpful

[@flexitrain]

This is indeed a good one. Excellent Tutorial.

[@prashantjadhav5440]

very good video...Thanks a lot for sharing

[@manojrao9867]

Good Explanation ...thanks

[@ga7853]

Thank you so much, that was really useful to know.

[@prachirandive.7195]

Amazing... Thanks

[@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 !