Ranking & Top-N per Group SQL interview questions
'Top N per group' and 'latest row per key' appear in nearly every SQL screen. Know when ties should be kept (RANK) and when you need exactly one row (ROW_NUMBER with a tie-breaker).
- Most Recent Order per CustomerWindow Functions · Ranking & Top-N per Groupeasy
- Top 2 Products in Each CategoryfreeWindow Functions · Ranking & Top-N per Groupmedium
- Top 2 Earning Drivers in Each CityWindow Functions · Ranking & Top-N per Groupmedium
- Longest Completed Trip in Each CityWindow Functions · Ranking & Top-N per Groupmedium
- Best Day for Each CampaignWindow Functions · Ranking & Top-N per Groupmedium