Database Engines and ANSI SQL Compliance

sql database standards ansi-sql
bitblit picture bitblit · Aug 30, 2010 · Viewed 15k times · Source

I've been searching for half an hour and can't find any resources stating what level of the SQL ANSI standard is supported on various database engines.

It looks like some level of support is provided by most engines, but I'd like to know exactly what level is officially supported.

I'm primarily interested in MySQL, PostgreSQL, SQL Server, and Oracle.

EDIT: PostgreSQL has a great page on compliance, exactly what I was looking for regarding the other engines: http://www.postgresql.org/docs/current/interactive/features.html

Answer

KM. picture KM. · Aug 30, 2010

these might help a little:

Comparison of different SQL implementations

wikipedia - Comparison of relational database management systems

wikipedia - SQL - Standardization

Related questions

What are some of your most useful database standards?

I have some ideas, some that I have accumulated over time, but I really want to know what makes things go smoothly for you when modeling database: Table name matches Primary Key name and description key Schemas are by functional …

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More