Practice · 1 of 3

SELECT Filter Simulator

Write selectRows(rows, spec) — rows is an array of objects; spec is { where: { col: value }?, orderBy?: [col, "asc"|"desc"], limit?, offset? }. Apply WHERE (all pairs must equal; a spec value of null matches rows where the column IS null), ORDER BY (stable), then OFFSET, then LIMIT. Return the resulting array.

Difficulty: intermediate

Press Submit to check your solution.

Back to lesson: Practice: SQL Mechanics — Practice