In 1989, the American National Standards Institute (http://www.ansi.org) published the first 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.
Bnf Grammar: