SQL Standard and resources for comparison between non-standard SQL versions | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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)?

27th Feb 2021, 5:19 PM
Giuseppe Pipitò
1 Answer
+ 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/
28th Feb 2021, 6:37 AM
XXX
XXX - avatar