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

Рет қаралды 526,664

Күн бұрын

For more such videos visit www.questpond.com
For more such videos subscribe www.youtube.co...
See our other Step by Step video series below :-
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5...
Learn Power BI Step by Step:- tinyurl.com/y6...
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Learn Tableau step by step :- tinyurl.com/kh...
Learn SQL Server Step by Step tinyurl.com/ja4...
Learn Angular tutorial step by step tinyurl.com/yc...
Learn MVC Core step by step :- tinyurl.com/y9j...
Learn C# Step by Step goo.gl/FNlqn3
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn Azure Step by Step :- tinyurl.com/y6...
Learn SharePoint Step by Step in 8 hours:- goo.gl/XQKHeP
SQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?
We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on questpond@questpond.com with the shared link and we will email you the PDF.

Пікірлер: 249

@dnfvideo 3 жыл бұрын

Do not miss our Interview Question video series 30 Important C# Interview Questions : kzfaq.info/get/bejne/eLGpoahztdfNeYE.html 25 Important ASP.NET Interview Questions : kzfaq.info/get/bejne/pr6dgMeer7unYJs.html 25 Angular Interview Questions : kzfaq.info/get/bejne/Y9CVotx1r6rXg4E.html 5 MSBI Interview Questions : kzfaq.info/get/bejne/a6toZJiSvafbiYU.html

@ARJUN-op2dh 4 жыл бұрын

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

@RohanRamVaswani 3 жыл бұрын

2021

@arkapoddar3727 2 жыл бұрын

Agreed

@vrindavaneshwari_ju_ki_kripa 2 жыл бұрын

abe ha bhai 2022 me b

@rahulmittal116 2 жыл бұрын

Want to learn SQL from scratch - Subscribe to kzfaq.info/love/-yCdYQYwNy7ZVzQ9FfAgqA and start with 1st video. SQL Joins video - kzfaq.info/get/bejne/oK-eo5qG3puolXk.html SQL tutorial is here for you

@biplabbaishnab3926 2 жыл бұрын

In 2022 as well

@rohitekka2674 2 жыл бұрын

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 5 жыл бұрын

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 😊🐕😙

@pranavbhat92 8 ай бұрын

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

@CreatingUtopia 3 жыл бұрын

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 3 жыл бұрын

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

@88spaces 5 жыл бұрын

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.

@noronhasanjay 2 жыл бұрын

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

@SumanDas-df5df Жыл бұрын

He is Shiv Koirala

@yuvrajpardeshi1429 2 жыл бұрын

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 2 жыл бұрын

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

@krithikakumaragurubaran7110 2 жыл бұрын

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

@dnfvideo 4 жыл бұрын

Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com. If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free. kzfaq.info/get/bejne/g8ichbWi0cqVlps.html

@pankajjasrotia4178 11 жыл бұрын

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

@renobramantyo5069 Жыл бұрын

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

@theunusual4566 Жыл бұрын

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

@subtlehustle6300 2 жыл бұрын

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

@GabrielPosternak 3 жыл бұрын

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

@ayandey15 3 жыл бұрын

U simply taught a complex function. Thank u

@shwetabudake6144 3 жыл бұрын

Awesome, very clear explanation within 10min.

@raveenachakrapani1090 2 жыл бұрын

Very helpful video. Explained the concepts in 10 mins

@ilyasmohamed8231 10 жыл бұрын

voice is v clr n explained v wel. thnk

@Anubis10110 3 жыл бұрын

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

@MatteoPratesi 9 жыл бұрын

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

@benlong1062 Жыл бұрын

Very clear and easy to understand, Thanks

@ankitasurjushe9150 2 жыл бұрын

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 !

@krantikumar894 2 жыл бұрын

Really njoyed and easily understand the concept tq sir

@ananth889 7 жыл бұрын

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

@benyams8014 7 жыл бұрын

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

@arandomchannel56 2 жыл бұрын

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

@nitinyog 3 жыл бұрын

Superior Tutorial. Helpful and Understandable .

@take_the_trade 3 жыл бұрын

This is simply great explanation with practical

@mayurpawar411 4 жыл бұрын

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

@chaitanya2725 3 жыл бұрын

Great Explanation

@sapien4 11 жыл бұрын

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

@sureshsunkara4396 11 жыл бұрын

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

@vamsikonidla6912 4 жыл бұрын

Super explanation.

@mohammadmamun5193 4 жыл бұрын

Very clear and simple explanation.Thank you!

@piyalichatterjee1532 2 жыл бұрын

Very nice explanation, thank you for this video

@shafiaaskari5949 3 жыл бұрын

Loved it. Thank you for making this 👏🏻

@gunupatihymavathi6114 2 жыл бұрын

hi sir you are explained very well compare with others lectures

@ramanujkumar9991 2 жыл бұрын

Great explained sir,i was looking this only

@LukeArthurBates 5 жыл бұрын

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

@iemranee 4 жыл бұрын

Very well explained. You are an awesome teacher

@anawadtom6011 2 жыл бұрын

Good clear explanation. Thanks!

@mandarTube 7 жыл бұрын

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

@kedardatar9259 4 жыл бұрын

Enjoyed explanation. I understand concept quickly

@akashsharma9210 Жыл бұрын

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

@schaumaul 3 жыл бұрын

this guy is a legend.

@ichak13 9 жыл бұрын

You have explained it very lucidly..Thanks!

@maheshbabunadigoti7050 4 жыл бұрын

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

@shubhambansla3824 5 жыл бұрын

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

@beinghuman77733 3 жыл бұрын

Very Good Explanation

@nasrealam5496 7 жыл бұрын

A very comprehensive video.. Kudos !

@vanajag2576 4 жыл бұрын

Awesome explanation sir thank so much sir

@olgab3290 9 жыл бұрын

Very well! Very clear, easy to understand.

@EconomiKally 5 жыл бұрын

Awesome explanation. You are a blessed teacher.

@satishnagotkar886 7 жыл бұрын

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

@RameshKumar-ng3nf 6 жыл бұрын

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. :-)

@nabeelusmani5937 Жыл бұрын

Very well explained 🔥

@devashishghosh7497 Жыл бұрын

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

@Rahulkumar-ni8oh 3 жыл бұрын

Very good explanation...

@mohammedaasem1574 3 жыл бұрын

This is what I was looking for 👍 Very useful

@rajdhanibeats4060 3 жыл бұрын

Great explanation. Thank you

@muraliraj9658 5 жыл бұрын

wonderful Explanation sir..simply superb.

@babzo1 10 жыл бұрын

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

@rozario1309 2 жыл бұрын

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?

@manjunatht7087 5 жыл бұрын

Well explained. Understood clearly.Thank you

@thebluehurricane 9 жыл бұрын

Very clear and easy to follow, thanks.

@namratanikam7566 3 жыл бұрын

Very well explained😊

@jk787 4 жыл бұрын

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

@parmeshwarlahole1365 3 жыл бұрын

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

@jinyang4796 2 жыл бұрын

Very neatly explained! Thank you so much! :D

@prasunjeetsoni6143 5 жыл бұрын

I learnt new things ... thanks mentor

@Balajiji4888 2 ай бұрын

Thanks Sir

@diftq8191 2 жыл бұрын

what happens if you just select row_number()? Without the over window functions?

@SanjayKumar-yh8fd 3 жыл бұрын

very well explanation

@sid-abhay 4 жыл бұрын

Very well explained. Thank you

@ga7853 5 жыл бұрын

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

@Sidharthpatil3001 9 жыл бұрын

fabulous!! keep coming up with such fantastic tutorials. All D best

@Naru_NNN 4 жыл бұрын

Simply clear

@rishabhsharma329 4 жыл бұрын

This is phenomenal !

@lalaniwerake881 4 жыл бұрын

Nice video.. very helpful - Thanks

@himanshu7103 11 ай бұрын

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

@idontdotravelhoney 3 жыл бұрын

What a neat explanation!!👍👍

@priyasingh9984 5 жыл бұрын

very well explained. short and best

@vamsikonidla6912 4 жыл бұрын

Super explanation

@nssramya8792 Жыл бұрын

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

@rahulchugh6694 5 жыл бұрын

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

@syedmunazzirahmed3191 7 жыл бұрын

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

@ApoorvNaramdeo 7 жыл бұрын

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 5 жыл бұрын

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