Advanced SQL
Window Functions SQL Lessons
Learn OVER, PARTITION BY, ROW_NUMBER, LAG/LEAD through focused tutorials and business-data examples.
Lessons in this category
SQL Window FunctionsRead lesson Understanding SQL WindowsRead lesson SQL OVER ClauseRead lesson SQL PARTITION BYRead lesson SQL ORDER BY in a Window FunctionRead lesson SQL Window Function vs GROUP BYRead lesson SQL ROW_NUMBERRead lesson SQL RANKRead lesson SQL DENSE_RANKRead lesson SQL ROW_NUMBER vs RANKRead lesson SQL RANK vs DENSE_RANKRead lesson SQL NTILERead lesson SQL LAGRead lesson SQL LEADRead lesson SQL FIRST_VALUERead lesson SQL LAST_VALUERead lesson SQL NTH_VALUERead lesson SQL SUM OVERRead lesson SQL AVG OVERRead lesson SQL COUNT OVERRead lesson SQL MIN OVERRead lesson SQL MAX OVERRead lesson SQL Window FramesRead lesson SQL ROWS BETWEENRead lesson SQL RANGE BETWEENRead lesson SQL UNBOUNDED PRECEDINGRead lesson SQL CURRENT ROWRead lesson SQL Moving Window FramesRead lesson SQL Running TotalRead lesson SQL Cumulative SumRead lesson SQL Moving AverageRead lesson SQL Rolling AverageRead lesson SQL Previous Row ComparisonRead lesson SQL Next Row ComparisonRead lesson SQL Percent of TotalRead lesson SQL Ranking Within GroupsRead lesson SQL Top N per GroupRead lesson SQL Deduplicate Rows with ROW_NUMBERRead lesson SQL First Event per UserRead lesson SQL Latest Record per CustomerRead lesson SQL Month-over-Month GrowthRead lesson SQL Year-over-Year GrowthRead lesson