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

SQL Pocket Guide author Alice Zhao breaks down each part of a window function, step-by-step. 🎉 UP TO 50% OFF SPRING SAVINGS 🎉 The LOWEST PRICING of the season starts NOW! AI is reshaping every industry, and the professionals who will thrive aren’t waiting to figure it out. They’re building real skills right now. You can, too! For Spring Savings, you can choose from 3 great offers through May 6th: 👉 Monthly plan: 25% off your first 3 months ($36.75/mo) 👉 Annual plan: 50% off your first year ($199.50/yr) 👉 Lifetime access: 50% off, forever ($849.50) All Maven Pro memberships include: ✓ Unlimited access to ALL courses & learning paths ✓ Customized learning plans ✓ Guided projects ✓ Skills assessments ✓ Showcase portfolio builder ✓ Free practice data sets ✓ Private student dashboard ✓ Live instructor chat support Plus something brand NEW, launching soon...👀 Build job-ready AI + data skills, all in one membership. SAVE NOW 👉 https://bit.ly/4cXXTHo Hope to see you there! 🔗 Helpful Links: 👉 Alice's Advanced SQL Querying course: https://bit.ly/3ZgI0Xa 👉 MySQL Specialist Learning Path: https://mavenanalytics.io/path/mysql-specialist 👉 Follow Alice: https://www.linkedin.com/in/alicexzhao 👉 Follow Maven Analytics: https://www.linkedin.com/company/maven-analytics ⏱️ 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 📄 CREATE & INSERT Statements 📄 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); At Maven Analytics, we empower everyday people with life-changing data & AI skills. Head to http://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: https://mavenanalytics.io/guided-projects