Code AnalysisIntermediate 60s

Offset pagination instability

Data is inserted while a client pages through. What goes wrong with this approach?

Starter code

SELECT * FROM posts ORDER BY created_at DESC LIMIT 20 OFFSET 40;

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.