Langues
Saisie de Code
Extraits SQL
Pratique de saisie SQL.
INNER JOIN
Join customers and orders, project a flat report.
GROUP BY with HAVINGAggregate customer spend and filter high-value accounts.
Window FunctionRank orders by total within each customer.
Recursive CTEWalk a category tree from the root down.
UPSERTInsert or update on conflict (PostgreSQL syntax).
Composite IndexAccelerate a common query with a multi-column index.