SQL Reference Guides

Welcome to the SQL reference page. Here you can find links to the reference pages of the major databases.

Database	Reference
MySQL	https://dev.mysql.com/doc/refman/8.0/en/
PostgreSQL	https://www.postgresql.org/docs/current/sql-commands.html
SQL Server	https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation
Oracle	https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/index.html
Sqlite	https://www.sqlite.org/docs.html
IBM Db2	https://www.ibm.com/docs/en/i/7.2?topic=reference-sql

Here is a brief introduction to each vendor's implementation of SQL.

Vendor	Implementation	Notes
MySQL	ANSI SQL	MySQL supports most of the ANSI SQL standard, with some variations and extensions. It is widely used in web applications and is known for its ease of use and high performance.
PostgreSQL	ANSI SQL	PostgreSQL is an open-source database that supports most of the ANSI SQL standard, with some variations and extensions. It is known for its strong support for transactional processing and for its robust set of data types and indexing options.
Oracle	ANSI SQL	Oracle is a commercial database that supports most of the ANSI SQL standard, with some variations and extensions. It is known for its strong support for transactional processing and for its high performance and scalability.
Microsoft SQL Server	ANSI SQL	Microsoft SQL Server is a commercial database that supports most of the ANSI SQL standard, with some variations and extensions. It is known for its strong support for transactional processing and for its integration with other Microsoft products.
SQLite	ANSI SQL	SQLite is an embedded database that supports most of the ANSI SQL standard, with some variations and extensions. It is known for its small size, ease of use, and high performance.
IBM DB2	ANSI SQL	IBM DB2 is a commercial database that supports most of the ANSI SQL standard, with some variations and extensions. It is known for its strong support for transactional processing and for its high performance and scalability.