PARTITION BY, RANK() and DENSE_RANK()

This video explains SQL Analytical Functions RANK(), DENSE_RANK and PARTITION_BY. You will be convinced that you need to use ANALYTICAL QUERIES in order to get a SQL job. No exceptions!!!
Link to my SQL Courses on Udemy: www.udemy.com/...

[@ebenreuben]

Clarity ,humor and Content superb 10/10

[@SQLUniversity]

Thank you!

[@SQLUniversity]

Thank You, Eben!

[@MountRushCollymore]

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

[@SQLUniversity]

Thank You, @MountRushCollymore!

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

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

[@AjayPrashar]

Well done, Sir.

[@danielgovender5263]

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

[@usa_online]

Great explanations , thank you so much 🙏

[@abdulazizmohammed6300]

very informative, thank you.

[@SQLUniversity]

Thanks Abdul!

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

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

[@onazeumoru162]

Explained like we are 5😃😃😃🤗💓💕

[@SQLUniversity]

I love the feed back! Thanks!

[@utkuberkaydn5834]

10/10 it was really helpful

[@TheSeveer123]

Thank you!!

[@gal05031]

good video !

[@solapeajogbasile5915]

Informative and funny

[@SQLUniversity]

Thank You!

[@simonvallejovalencia2218]

great!!!

[@SQLUniversity]

Thank You, Simon!

[@BCHabana]

🎉

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

[@Gowthamsgalleryvlogs]

Awesome Brother , Thanks for sharing
🥰

[@SQLUniversity]

Thanks ✌️

[@SQLUniversity]

Thanks for your kind words!

[@dimitarstoymirov2285]

got it very quickly thanks

[@abdulazizmohammed6300]

Bro you are funny

[@SQLUniversity]

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

[@techieshit4648]

Great sir!

[@SQLUniversity]

Thanks TS!!

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

[@danielgovender5263]

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

[@stonebubbleprivat]

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

[@SQLUniversity]

Thanks for the feedback!