SQL: SELECT with WHERE and ORDER BY

A short, tested SQL example for select with where and order by. Copy it and adjust the names and paths for your project.

SQL

SELECT id, name, created_at
FROM users
WHERE active = true AND age >= 18
ORDER BY created_at DESC
LIMIT 20;

Find it in Zest

Search for “sql select with where and order by” in Zest and this example appears above the results, with other matches to choose from. Searches stay private.

More SQL examples

JOIN types GROUP BY and HAVING INSERT, UPDATE and DELETE CREATE TABLE Create an index Common table expression (WITH)Window function: ROW_NUMBER Upsert (insert or update)

All SQL examples