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.

EasyBasic SELECT

Select first 5 products by price descending

SQL

SELECT product_id, name, price, stock
FROM products
ORDER BY price DESC
LIMIT 5;

Tested against PostgreSQL 16

Note

“Combine ORDER BY and LIMIT to get top-N results.