SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)
Table of Contents
About
In 1989, the American National Standards Institute (http://www.ansi.org) published a SQL specification of the ANSI SQL.
The ANSI SQL standard revision:
Year | Year Reference | Ordering reference | Iso (Specification) |
---|---|---|---|
1989 | |||
1992 | SQL-92 | SQL-2 | sql1992.txt or ISO/IEC 9075:1992 |
1999 | SQL-99 | SQL-3 | |
2003 | SQL:2003 | ISO/IEC 9075-2:2003 | |
2011 | Part 1 SQL Framework |
Most major database vendors support the SQL-92 standard. However, the levels of conformance vary. Some vendors have gone beyond the SQL-92 standard and most have their own extensions to the SQL language.
One of the reproach that you can find concerning the ANSI SQL syntax is that it separates join predicates from filter predicates.
Grammar
Documentation / Reference
- You can download the SQL:200n working documents from Whitemarsh Information Systems Corp.
- Several revisions of the SQL Standards working documents are available from the SQL Standards Organization website.