Window Functions
15 practice items · needed by 3 roles
Easy 0Medium 9Hard 6
Practice questions
- Latest order per customermedium
- Ranking with ties in SQLmedium
- Latest order per customermedium
- Running total of salesmedium
- RANK vs DENSE_RANK after a tiemedium
- Month-over-month change with LAGmedium
- Running total with tied dateshard
- NTILE with 10 rowshard
- Latest order changes between runshard
- Keeping the latest row per keymedium
- RANK and DENSE_RANK with tiesmedium
- Day-over-day change with LAGmedium
- Running total with tied dateshard
- LAST_VALUE returns the current rowhard
- Longest login streakhard