Don't Tell Anyone: The SQL Standard is Public!

Picture of ISO/IEC 9075 CD

We all love open source software. Wouldn’t it be great if international standard documents such as the SQL standard would be open too?

As a matter of fact: they are!

However, they are not free—just public. Very much like open source software is not necessarily free. Too often, we neglect these differences. Just because we have to pay for the standard doesn't mean it is secret.

A download of the most relevant part of the SQL standard—part 2—is available for EUR 180 at Austrian Standards. The 2011 version can still be bought for USD 60 at ANSI. It might pay off to check the prices at other ISO members. The SQL standards is not free, but affordable.

Nevertheless there are some free resources that can help you answering questions about the SQL standard:


What's new in SQL:2016?

ISO released some highly relevant technical reports for free:

Also note that I've written about the following features: listagg.


Recommended articles (PDF):

Part 1 can be downloaded free of charge from ISO

ISO released a free technical report on “SQL Support for Time-Related Information” (covers temporal tables).

Browsable BNF grammar of Part 2 and Part 4.

Drafts of all parts are linked as “SQL:20nn Working Draft Documents” at


Browsable BNF grammar of Part 2.


Browsable BNF grammar of Part 2 (alternative source).


The full content of the book “SQL-99 Complete, Really” is available online and for free at the MariaDB knowledge base. In total conflict to its title, the book only covers Core SQL:1999.

Online validator at

Browsable BNF grammar of Part 2 (alternative source).


A draft of the standard text is available at

Online validator at

Browsable BNF grammar of Part 2 (alternative source).

About the Author

Photo of Markus Winand

Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing. His book entitled SQL Performance Explained has become standard reading.

Buy his Book on Amazon

Cover of “SQL Performance Explained”: Squirrel running on grass

The essence of SQL tuning in 200 pages

Buy on Amazon
(paperback only)

Paperback and PDF also available at Markus’ store.

Hire Markus

Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »

“modern SQL” by Markus Winand is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 Unported License.
Legal | Contact | NO WARRANTY | Trademarks | Privacy and GDPR | CC-BY-NC-ND 3.0 license