Sorting and pagination
DraftSQL tables do not promise a natural order. Use ORDER BY when order matters, then LIMIT and OFFSET when you want a page.
Sort rows
ORDER BY makes result order explicit instead of trusting table storage order.
Loaded Database:sorting-and-pagination.database-init
SELECT name, starts_at
FROM events
ORDER BY starts_at DESC;Loading plan...Limit and offset
LIMIT and OFFSET can fetch one page from a larger ordered result.
Loaded Database:sorting-and-pagination.database-init
SELECT name, starts_at
FROM events
ORDER BY starts_at DESC
LIMIT 2 OFFSET 2;Loading plan...Sort with an index
An index with the same order can let PostgreSQL avoid a separate sort step.
Loaded Database:sorting-and-pagination.database-init
SELECT name, starts_at
FROM events
ORDER BY starts_at DESC
LIMIT 1;Loading plan...