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

1 - About

In 1989, the American National Standards Institute (http://www.ansi.org) published a SQL specification

The ANSI SQL standard revision:

Year Year Reference Ordering reference Iso (Specification)
1989
1992 SQL-92 SQL-2 ISO/IEC 9075:1992
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.

3 - Grammar

Bnf Grammar:

4 - Documentation / Reference

  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at del.icio.us
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Digg
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Ask
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Google
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at StumbleUpon
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Technorati
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Live Bookmarks
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Yahoo! Myweb
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Facebook
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Yahoo! Bookmarks
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at Twitter
  • Bookmark "SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011)" at myAOL