Сохраненная страница SQL dialects reference - Wikibooks, collection of open-content textbooks (22 Kb)

Several SQL dialects are covered in this book. Note that in all cases of particular implementations, only the latest stable version is described.

* Standard. There are several versions of SQL standard (SQL-86, SQL-89, SQL-92, SQL:1999, SQL:2003). The book would list all popular practices to do a job in all implementations, particularly emphasizing SQL versions that a particular solution works for (i.e. if some feature became standard since version X, it would be stated that such solution works since version X).
* DB2 (IBM DB2).
* Firebird (Firebird 2.0). An open-source RDBMS forked from sources of InterBase that were released by Borland on July 25, 2000. Being a fork, most of the documentation is also true for InterBase.
* MySQL (MySQL 5.0)
* MSSQL (Microsoft SQL Server 2005).
* Oracle (Oracle Database 10g2)
* PostgreSQL (PostgreSQL 8.2)
* SQLite.
* Virtuoso (OpenLink Virtuoso running on Virtuoso Universal Server).
* Linter