Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


ANSI SQL Guidelines

What is ANSI SQL? Why This Forum? by tlbroadbent
Posted: 5 Sep 01 (Edited 4 Feb 03)

The ANSI SQL forum exists to discuss programming in Structured Query Language (SQL), independent of a specific implementation or RDMS. SQL is a widely used language for data retrieval and manipulation in databases.

In 1989, the American National Standards Institute (http://www.ansi.org) published a SQL specification. The ANSI SQL standard was revised in 1992 and this is often referred to as SQL-92 or SQL-2. View the SQL-92 standards draft document.


SQL-99 or SQL:1999 is the current standard. SQL-99 is sometimes called SQL-3.

The latest standard is SQL:2003 or SQL:200n. This standard is currently under development. 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.


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.

Michael Gorman wrote an article, ôIs Sql A Real Standard Anymore?,ö  for the April 2001 issue of ôThe Data Administration Newsletterö from TDAN.


Peter Gulutzan authored an article on the ôSQL Standardö for the Jan. 2003 issue of ôThe Data Administration Newsletterö from TDAN.


More articles related to SQL can be found at


The United States Federal Information Processing Standards Publication, ôStandard for Database Language SQLö can be downloaded from http://www.itl.nist.gov/fipspubs/fip127-2.htm.

A number of database forums exist on Tek-Tips where database or RDMS specific questions can be answered. As mentioned, most database products do not fully comply with the ANSI SQL-92 or SQL-99 standards. As a result, an ANSI SQL solution may not work in a particular database. Therefore, if you use one of the products listed below and your question pertains to the product, you'll probably get an answer more quickly in a forum for that product.

Forum177 Corel: Paradox Forum
Forum178 IBM: DB2 Forum
Forum179 Informix: Informix Dynamic Server Forum
Forum181 Microsoft: Access General discussion Forum
Forum701 Microsoft: Access Queries and Access/SQL Forum
Forum183 Microsoft: SQL Server Forum
Forum259 Oracle: Developer Forum
Forum119 Oracle: Enterprise Developer Suite Forum
Forum185 Oracle: Oracle release 5, 6, and 7 Forum
Forum186 Oracle: Oracle release 8 and 8i Forum
Forum759 Oracle: Oracle release 9i Forum
Forum318 Pervasive: Pervasive.SQL Forum
Forum699 PostgreSQL Inc: PostgreSQL Forum
Forum188 Sybase: SQL Server Forum
Forum352 Sylvain Faust, Intl (SFI): SQL-Programmer Forum
Forum436 T.C.X DataKonsult AB: MySQL Forum


Please feel free to comment, suggest revisions and/or additional forums to include in the list.

Back to ANSI_SQL FAQ Index
Back to ANSI_SQL Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close