SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK

[@pradeepyenni1723]

Finally i understood how the SQL window functions ........................thank you soo much

[@MrDeeraf]

Hands down the most straightforward explanation of window functions!

[@thepriestofvaranasi]

Best explanation ever. Also, the way you smile through the entire video is very cute lol. Love your smile.

[@hiddenworld8280]

Loved the teaching style. Very simple yet effective explaination. Thanks!

[@Epic-so3ek]

super underrated

[@kingsleyarisah6354]

Best Teacher I've seen on KZbin hands down

[@j4ta680]

As a fellow educator, I know great quality when I see it. Great job, Alice! You explained some very difficult concepts very clearly and succinctly. Well done!

[@Alice-at-Maven]

Thank you!

[@abeleadekwu3825]

Best SQL tutor ever, you are amazing!!!

[@Alice-at-Maven]

Thank you! Glad the video was helpful!

[@berj2421]

Amazing video! THE best educational video I have ever seen on KZbin. Short, simple, and straight to the point, Thank you, Alice! As someone with ADHD, it's hard to find videos where there isn't a lot going on the screen to distract me from the message, or the explanations aren't clear, or instructors are trying so hard to make sure viewers understand they start overexplaining and talking in circles. Even if I rewind and listen over and over, I can't pay attention long enough to get through the explanations and then I get angry at myself for not being able to listen. I know a lot of people won't understand this or think I'm exaggerating, but this video was so easy to follow (which never happens for me) I want to cry.

[@Alice-at-Maven]

You're welcome! I'm so happy to hear that ☺

[@Yonathanmoure]

Brilliant Video! DENSE_RANK is just what I needed.

[@rajeshantony74]

crispy clear and to the point

[@souhardya1487]

your teaching style so good mam

[@Alice-at-Maven]

Thank you!

[@vivektarab1959]

0:03 - What are Windows Functions 0:53 - Descending se Popularity daalna h 2:36 - Now I wanna Pass Here 3:27 - Going down here 4:35 - First Value and Nth Value 4:40 - Lead and Lag

[@kikelomojaji2885]

very straightforward and understandable in a simple format

[@coolestviplov]

Awesome explanation 🙌🏻

[@rodrigochavez7]

Always was difficult to me understand these concepts about Windows functions specifically but this video summarize a lot of videos with practical examples making easy to apply with confidence. Thank you Alice!

[@Alice-at-Maven]

You're welcome!

[@carlosserra1588]

Great video on subqueries and window functions! @Alice Zhao, you have a knack for making complex concepts understandable. I especially appreciated how you broke down the window function. Looking forward to more content in this new format! #MavenAnalytics #SQL

[@Alice-at-Maven]

Thank you! We are working on it :)

[@JhulanDey]

One of the best-in-class explanations!

[@hypershadow9226]

very informative. Thank you

[@mehdiabdennadher7407]

thank you.

[@Morero1000]

You explain so clearly and so well put. it just makes it so much easier to understand. Thank you!

[@jphd21]

Saving this video!! Fantastic explanation👏👏

[@Alice-at-Maven]

🙌

[@humzakhan766]

Just paused the video to say that you are just AMAZING. Thank you for such an eloquent explanation. God Bless you!

[@Alice-at-Maven]

Thank you! Glad you enjoyed the video ☺

[@tauseefhashmi]

The best Window Function, Partition By and Row Number, Tried multiple videos and still couldn't understand properly, this video explains the concepts perfectly. Thank you so much @AliceZhao @MavenAnalytics 🙌🏻

[@Alice-at-Maven]

You're welcome!

[@Fin143]

The best explanation I've ever seen

[@Alice-at-Maven]

Thank you!

[@sanjanashuklaa2031]

amazingly explained

[@alihezarpisheh8350]

Solid Explanation! Thanks

[@Alice-at-Maven]

Glad you enjoyed it!

[@mpholurking]

Thanks for this simplified explanation, i had been having a hard time understanding window functions. I like that you give examples of a problem to answer.

[@Alice-at-Maven]

Glad it was helpful!

[@shirinhashim]

Wow Alice. You have brilliantly explained window functions. I hope to see more content like this. Cheers

[@Alice-at-Maven]

Thank you! We are working on it, stay tuned!

[@moody_moony123]

finally, I understand window functions, pitty I should have watech video before my last interview!!

[@RoommateWiLLE]

Straightforward and to the point! Thank you! I used to beat my head against the computer learning these years ago.

[@Alice-at-Maven]

You're welcome! Glad the video made it less painful this time around!

[@pirate185]

Amazing explanations plus the smile 😄

[@sayowhatisuupmynaiba]

Thank you for your videos, very insightful and easy to understand, straightforward without unnecessary talking.

[@Alice-at-Maven]

Glad you enjoyed it!

[@sambeetpanda6919]

Thanks so much for this ,finally understood the concept.

[@Alice-at-Maven]

Glad to hear that!

[@stevenlomon]

Clear and amazing explanation, thank you so much!! 🙌

[@Alice-at-Maven]

You're welcome!

[@TheSGOGS]

Amazing explanation thank you

[@Alice-at-Maven]

Glad it was helpful!

[@edieshaw7247]

Finally understand window functions! Great tutorial.

[@Alice-at-Maven]

🙌

[@keagankemp6275]

Wow, with your classes I will be a sql boss

[@Alice-at-Maven]

🙌

[@gpisty8430]

Brava brava brava Alice! Very well done, clear and concise... also very useful and interesting

[@Alice-at-Maven]

Glad you enjoyed it!

[@jakubosiecki1796]

If my wife would ever learned SQL she would love this dataset ;)

[@Alice-at-Maven]

Love this comment. It's one of my favorite data sets to work with!

[@yosefbadwey1311]

a lot of thanks, you so great, i got it, thankkkkks, i wish you a great day like you did mine,

[@codewkarim]

CRYSTAL CLEAR, THANKS!

[@Alice-at-Maven]

You're welcome!

[@omilkhouseo]

GIRL THANK YOU better than this damn pluralsight course

[@nik54610]

more videos on sql please

[@roycemekolle7334]

She is a great teacher

[@tomodachi7095]

This helped me solve leetcode hard 185. Department Top Three Salaries

[@arneshguru4263]

Nice explanation.

[@aman-alytics]

Thanks for explanation ❤

[@rolipoli7601]

I instantly understand subquery

[@Alice-at-Maven]

🙌

[@squidproxy136]

very useful, thanks

[@GenetSebehat]

It is great explanation!

[@shrishtimanja1849]

how does one identify when to use the subquery? I thought limit by could have been used but instead the subquery was used. Could you explain that please?

[@iamstevenarmas]

Thank youuuuuuuuuuuu

[@Alice-at-Maven]

You're welcome!

[@gurvindersingharora5301]

Hello Sir, Thank you for your useful videos on dax. Sir, when to combine ALL function with Calculate + Filter Function together in Dax ? Could you please make a video of it in detail soon 🙏

[@connectwithme3567]

Very nice explanation, but where are lead and lag functions ?

[@Alice-at-Maven]

I briefly mention them at 4:31. They are two of many functions you can use when working with window functions. You can swap out the ROW_NUMBER() function with LEAD(Total) or LAG(Total) to get the next row's total and previous row's total values, respectively. I cover this more in depth in my Advanced SQL Querying course coming out next month on the Maven Analytics platform!

[@williamdela8894]

please where is the dataset you used for the video

[@Alice-at-Maven]

Here you go! CREATE TABLE baby_names ( Gender VARCHAR(10), Name VARCHAR(50), Total INT ); INSERT INTO baby_names (Gender, Name, Total) VALUES ('Girl', 'Ava', 95), ('Girl', 'Emma', 106), ('Boy', 'Ethan', 115), ('Girl', 'Isabella', 100), ('Boy', 'Jacob', 101), ('Boy', 'Liam', 84), ('Boy', 'Logan', 73), ('Boy', 'Noah', 120), ('Girl', 'Olivia', 100), ('Girl', 'Sophia', 88);

[@Test-e1i]

so I'm going to add a new RRROowwrughhh. that low voice at the end

[@lalopezcampeon3769]

wow

[@sulthankhan2047]

Subscribed

[@tusharsharma2359]

lovedthe video, hated the spoiled-newyork-cringe-Ahh-girl accent