PARTITION BY, RANK() and DENSE_RANK()

[@ebenreuben]

Clarity ,humor and Content superb 10/10

[@SQLUniversity]

Thank you!

[@SQLUniversity]

Thank You, Eben!

[@CerealforProtein]

thanks for having the different query sheets open to illustrate how a small change can really make all the difference in the final output. It also makes it easier to compare the queries as well, rather than scrubbing through the video to find the comparisons. Lastly, i appreciate the anecdotes, I had a good chuckle. A dedicated playlist of these SQL analytical functions would be very useful!

[@SQLUniversity]

CerealForProtein, thanks for the kind words! I try to make it as easy as possible!

[@AjayPrashar]

Well done, Sir.

[@MountRushCollymore]

Explained like we are all stupid, like marketers. Great stuff. Really clear.

[@SQLUniversity]

Thank You, @MountRushCollymore!

[@danielgovender5263]

Tbh this is the best video on these sections that ive found on yt

[@WewCode]

that was good, i really enjoyed it. I find myself using partion by a lot at work its nice to know how it works with different things thanks

[@abdulazizmohammed6300]

very informative, thank you.

[@SQLUniversity]

Thanks Abdul!

[@arthur5234z]

Great explanation. Love the anecdotes as well.

[@usa_online]

Great explanations , thank you so much 🙏

[@harshhes]

Damn man this is really helpful, Also this is a hard leetcode question now it seems to easy to solve. Thanks for sharing man

[@SQLUniversity]

Thanks Harsh!

[@Gowthamsgalleryvlogs]

Awesome Brother , Thanks for sharing
🥰

[@SQLUniversity]

Thanks ✌️

[@SQLUniversity]

Thanks for your kind words!

[@solapeajogbasile5915]

Informative and funny

[@SQLUniversity]

Thank You!

[@jamesleadbetter5546]

Really helpful and clear, thanks!
Any plans for videos on CTEs? Something that in theory I understand but would appreciate some clear video examples on. Particularly multiple CTEs.

[@SQLUniversity]

I would be happy to put together a video on CTE's for you. Anything in particular, other than multiples?

[@jamesleadbetter5546]

@@SQLUniversity thank you very much, it's greatly appreciated.
I don't think so, just something similar to this video: a clear explanation of why, how they work and some practical examples.
Thanks again!

[@SQLUniversity]

@@jamesleadbetter5546 you bet!

[@utkuberkaydn5834]

10/10 it was really helpful

[@onazeumoru162]

Explained like we are 5😃😃😃🤗💓💕

[@SQLUniversity]

I love the feed back! Thanks!

[@danielgovender5263]

I noticed people write a query " .....xxxxx (xxxxx) a" .. they dont write AS they just write the name outside the bracket and it picks up as an alias 🤔 is that a thing ?

[@aminabbaszadeh1066]

There is a big difference between people who study a material and then teach, and people who teach from their own experiences.
Good luck.

[@SQLUniversity]

Thanks @aminabbaszadeh1066 ! It means a lot.

[@JaredWelch]

the Smitty/Committee joke was a criminal act, but I guess we can let it slide because that was a good explanation 😛 Thanks!

[@techieshit4648]

Great sir!

[@SQLUniversity]

Thanks TS!!

[@gal05031]

good video !

[@simonvallejovalencia2218]

great!!!

[@SQLUniversity]

Thank You, Simon!

[@TheSeveer123]

Thank you!!

[@dimitarstoymirov2285]

got it very quickly thanks

[@abdulazizmohammed6300]

Bro you are funny

[@SQLUniversity]

Thanks @abdulazizmohammed6300, I try! (It's never rehearsed, it just happens!)

[@danielgovender5263]

Whats the chances that i left these sections to study for last and it happened to be in 1 video 😂

[@BCHabana]

🎉

[@stonebubbleprivat]

A lot of words but little substance. This could easily be a 4 minute video

[@SQLUniversity]

Thanks for the feedback!