← Paytm questions
Reported in a candidate post, Jul 2025

Duplicates, nth item per partition, self-join matches and running aggregate

Filed under Paytm

Solve four SQL tasks of increasing difficulty: remove duplicate rows, find the nth-ranked item within each partition, generate match combinations from a team table with a self join, and compute a…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Paytm questions

Collected from public candidate posts and coding forums. Updated Nov 2026.