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 all active employees

SQL

SELECT emp_id, first_name, last_name, job_title
FROM employees
WHERE status = 'active';

Tested against PostgreSQL 16

Note

“String comparisons in PostgreSQL are case-sensitive by default.