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

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

Рет қаралды 3,238

Ай бұрын

SQL Pocket Guide author Alice Zhao breaks down each part of a window function, step-by-step.
🔗 Helpful Links:
👉 MySQL Specialist Learning Path:
mavenanalytics.io/path/mysql-...
👉 Follow Alice:
/ alicexzhao
👉 Follow Maven Analytics:
/ maven-analytics
👀 Looking to learn (Excel/SQL) this summer? Join our upcoming Immersives and build job-ready skils in just 10 weeks!
bit.ly/3wPwoPw
⏱️ Timestamps ⏱️
00:00 Intro
0:09: View the table
0:28: ORDER BY
1:18: Window function with ROW_NUMBER
1:40: OVER
2:36: Breaking down the window function
3:28: ROW_NUMBER vs RANK vs DENSE_RANK
5:13: PARTITION BY
6:52: Window function in a subquery
At Maven Analytics, we empower everyday people with life-changing data & AI skills.
Head to mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE!
Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: mavenanalytics.io/guided-proj...

Пікірлер: 22

@edieshaw7247 10 күн бұрын

Finally understand window functions! Great tutorial.

@sambeetpanda6919 Ай бұрын

Thanks so much for this ,finally understood the concept.

@Alice-at-Maven Ай бұрын

Glad to hear that!

@gpisty8430 16 күн бұрын

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

@Alice-at-Maven 11 күн бұрын

Glad you enjoyed it!

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

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

@jphd21 Ай бұрын

Saving this video!! Fantastic explanation👏👏

@Alice-at-Maven Ай бұрын

🙌

@thehybridtech3260 Ай бұрын

Thanks for explanation ❤

@squidproxy136 Ай бұрын

very useful, thanks

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

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

@roycemekolle7334 23 күн бұрын

She is a great teacher

@GenetSebehat Ай бұрын

It is great explanation!

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

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