0
SQL Standard and resources for comparison between non-standard SQL versions
Each relational DBMS uses its own SQL syntax. Is there a site where I can find standard SQL syntax? Is there any resource (book, site, handout, manual, etc.) in which there are "tables" with the compared syntax used by the various DBMS (e.g.: MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server, Oracle)?
1 Antwort
+ 2
Quoted from this Wikipedia article:
https://en.m.wikipedia.org/wiki/SQL_syntax
"The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. *This standard is not freely available.*"
I don't really know what "this standad is not freely available means", but my best guess is, "this standard is not *publicly* available".
Here is a resource giving comparisons
http://troels.arvin.dk/db/rdbms/