Home / SQL / Window Functions

Window Functions

6 problems. Tick each as you solve it.

0 / 6 solved

• medium Day-over-Day Change with LAG and LEAD
• medium Deduplicate Rows with ROW_NUMBER
• medium RANK vs DENSE_RANK on Tied Scores
• medium Running Balance per Account
• hard 3-Day Trailing Moving Average
• hard Top 2 Earners per Department