Exercise · SQL & Querying
Predict, then run it
Predict the output
stalls(id, name) = (1,amber),(3,copal),(4,drift) — stall 2 closed since page 1 (which showed amber, brass). Fetch page 2 by keyset from the last id seen (2):
SELECT name FROM stalls WHERE id > 2 ORDER BY id LIMIT 2;
Predict the exact output.