Practice Uber SQL Question | Real Coding Interviews | Hack2hire

NewDark mode is now available across the siteSee what's new

Question Bank Pricing Blog Forum

Quick Summary

Retrieve the specific nth transaction record for every user based on chronological order.
Automatically exclude users who have fewer than n total transactions.
Requires ranking rows within user groups without collapsing the data.

What This Tests

Using window functions to generate sequential ranks within partitions.
Sorting data chronologically to ensure correct ranking order.
Filtering results based on a computed rank value.
Managing groups with varying row counts naturally through filtering.

Common Patterns

Window Function

Ranking

Subquery

Groupby

Test Cases

Input

-

Output

-

Expected

-