SQL Cheat Sheet
|
This section documents standard SQL (ISO/IEC 9075-2 (SQL/Foundation)) functionality only. Vendor-specific extensions or behavior of any particular database management system are intentionally left out. In the US, the standard is also distributed via ANSI’s webstore (search "ISO/IEC 9075"). This content was generated with the assistance of AI and should be verified against your target DBMS’s own documentation before relying on it in production. |
A single-page, color-coded summary of the most commonly used standard SQL statements and functions covered by
this reference — handy for quick memorization or as a printable desk reference. Each box groups one statement
family (DDL, SELECT, data modification, transactions, DCL, common functions, aggregate/window functions, and
JSON/XML/triggers) with its most essential syntax and a compact example.
For the full syntax, every option, and additional examples, see the dedicated pages: DDL, Queries (SELECT), Data Modification, Transactions, Data Control (DCL), Built-in Functions, Aggregate & Window Functions, JSON & XML Functions, and Triggers & Stored Procedures.