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.

FrontChaptersSchemaColophon
Chapters · Basic SELECT · Query 015 / 136
EasyBasic SELECT

Select customers from India or USA

The query

SQL
SELECT name, city, country
FROM customers
WHERE country IN ('India', 'USA', 'United States')
ORDER BY country, city;
Tested against PostgreSQL 16

Note

“IN is cleaner than multiple OR conditions and uses an index efficiently.

Tables referenced

  • customers6 cols

← Previous

Show products with stock between 10 and 100

Next →

Select all orders with NULL shipped_at (not shipped)

The Query & the Schema

Set in Fraunces and Inter Tight. Printed on parchment, in oxblood and ink. No tracking, no accounts, no JavaScript on the answer pages beyond what your browser needs to copy a query.

Compiled for Postgres 16 · MMXXVI