SQL for Data Analytics, Module 7: Window Functions

Module 7 of the free SQL for Data Analytics course. Window functions let you rank rows, build running totals and compare each month with the last, without losing a single row. Learn OVER, PARTITION BY, ROW_NUMBER, RANK and DENSE_RANK (and how they handle ties), LAG and LEAD, month-over-month growth, top-N-per-group queries, and how to keep one copy of each duplicate #SQL #SSMS #SQLServer #TSQL #DataAnalytics #LearnSQL #windowfunctions #growth #data