← Back to archive

Stdle #21 · grouping · 2026-06-27

What does this SQL snippet output?

A past puzzle — fully playable. 4 attempts, hints on wrong guesses.

CREATE TABLE t(v INTEGER);
INSERT INTO t VALUES (1),(2),(3),(4),(5);
SELECT v FROM t ORDER BY v DESC LIMIT 2 OFFSET 1
Grouping
2 lines
4 attempts left

Answer & explanation