Paginating Results

easy
Unit 9 · Case0/4 to milestone

An API lists orders newest first (by order_date descending, then id descending), 3 per page. Return page 2: the id and order_date of those orders.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#pagination#limit-offset1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Paginating Results · TechGradify