SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - 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 ISO/IEC 9075:1992, Sql 92
1999 SQL-99 SQL-3
2003 SQL:2003 ISO/IEC 9075-2:2003
2011 Part 1 SQL Framework

Search the Iso website with term SQL and the (publicly|free) available standard SQL are here

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.

Advertising

3 - Grammar

Bnf Grammar:

4 - Documentation / Reference

data/type/relation/sql/ansi.txt · Last modified: 2018/07/05 08:21 by gerardnico