Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyWHERE & Filtering

Find orders with total greater than 1000

SQL

SELECT order_id, cust_id, order_date, total, status
FROM orders
WHERE total > 1000
ORDER BY total DESC;

Tested against PostgreSQL 16

Note

“Simple numeric comparison. Useful for high-value order reports.