Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

DBMS Interview Problems

Chapters

TopicFile
Classic SQL ProblemsNth salary, duplicates, top N per group
Query OptimizationExecution plans, index usage
Join ProblemsLEFT JOIN traps, NOT IN nulls, EXISTS vs JOIN
Window Function ProblemsTop-row-per-group, running totals, gaps-and-islands
Concurrency ScenariosLost updates, deadlocks, isolation anomalies