Skip to content

Tracks Drills Topics Technologies Tech stacks Skill areas

Tracks Drills Topics

Loading

Aporeon interview preparation

About Privacy Terms

SQL Practical Query Problems

Windows & Pagination

Latest rows, top-N per group, keyset paging, running totals, streaks, hierarchy paths, and ranking.

6 drillsPractice one at a timeOrdered pathCoding problem

Recommended start

Latest Order Status

Uses ROW_NUMBER with a deterministic tie-breaker to return the complete latest status row per order.

Medium~25 minStep 1 of 6

Practice this drill Choose another

Search

6 of 6 shown

1Latest Order StatusRecommended startUses ROW_NUMBER with a deterministic tie-breaker to return the complete latest status row per order.Coding problemMedium~25 minSQLSQL ServerPractice 2Top Products Per Category

Practice order

6 drillsOne at a time

1Latest Order StatusUp next / Medium / ~25 min
2Top Products Per CategoryMedium / ~25 min
3Keyset Order PageMedium / ~25 min
4

Aggregates product sales and ranks independently inside each category with a deterministic top-N rule.

Coding problemMedium~25 minSQLSQL Server

Practice

3Keyset Order PageImplements descending keyset pagination with a compound cursor and stable ordering.Coding problemMedium~25 minSQLSQL ServerPractice

4Running BalanceUses an ordered window aggregate to calculate a deterministic running balance per account.Coding problemMedium~25 minSQLSQL ServerPractice

5Longest Login StreakUses the gaps-and-islands pattern to find consecutive login-day streaks after deduplicating same-day activity.Coding problemHard~35 minSQLSQL ServerPractice

6Category Tree PathsUses a recursive CTE to return hierarchy depth and a readable root-to-node path.Coding problemHard~35 minSQLSQL ServerPractice

Running Balance

Medium / ~25 min

5Longest Login StreakHard / ~35 min

6Category Tree PathsHard / ~35 min

Windows & Pagination - SQL Practical Query Problems | Aporeon