Ordering & Pagination — AQL

Ordering & Pagination

Order by

select User { id, email }
order by .created_at desc;

SELECT u.id AS id, u.email AS email
FROM "user" u
ORDER BY u.created_at DESC
LIMIT 1;

Multiple fields:

select User { id, email }
order by .active desc, .created_at asc;

Limit and offset

limit/offset require multi select (a plain select already returns a single row).

multi select User { id, email }
order by .created_at desc
limit $limit
offset $offset;

-- $1: limit
-- $2: offset
SELECT u.id AS id, u.email AS email
FROM "user" u
ORDER BY u.created_at DESC
LIMIT $1
OFFSET $2;

Combining clauses

multi select User { id, email, name }
filter .active = true and .age >= $min_age
order by .created_at desc
limit $limit
offset $offset;