Home
/
Questions
/
Coding
/
Top 3 debits per customer (DENSE_RANK)
caseSQL
Coding question · Top N Per Group
Easy
Asked at Capital One
Top 3 debits per customer (DENSE_RANK)
DENSE_RANK with PARTITION BY for top-N-per-group; tie semantics.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Trial-site enrollment rollup
Next →
Longest consecutive overdraft streak per account