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!

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

[@danielgovender5263]

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

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

[@solapeajogbasile5915]

Informative and funny

[@SQLUniversity]

Thank You!

[@Gowthamsgalleryvlogs]

Awesome Brother , Thanks for sharing
🥰

[@SQLUniversity]

Thanks ✌️

[@SQLUniversity]

Thanks for your kind words!

[@onazeumoru162]

Explained like we are 5😃😃😃🤗💓💕

[@SQLUniversity]

I love the feed back! Thanks!

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

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

[@abdulazizmohammed6300]

Bro you are funny

[@SQLUniversity]

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

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

[@simonvallejovalencia2218]

great!!!

[@SQLUniversity]

Thank You, Simon!

[@gal05031]

good video !

[@TheSeveer123]

Thank you!!

[@dimitarstoymirov2285]

got it very quickly 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 ?

[@BCHabana]

🎉

[@stonebubbleprivat]

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

[@SQLUniversity]

Thanks for the feedback!

[@danielgovender5263]

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