I am looking for a reference guide with the ability to use one or more comparison matrices for various SQL databases. The goal is to quickly see which SQL standards functions / statements / statements (yes, the plural will be good :) are supported by each and every syntax they use for them.
And then something similar for additional functions, perhaps by matching them with equivalent functions in other databases.
For example, I would like to be able to quickly see if the database A, B, C LIKEsupports the operator , and all of them support both tags %and _.
This Wikipedia Comparison of several RDBMSs mentioned in similar questions provides some interesting information, but not within the scope of syntactic functions and operator support.
Preferably, I am looking for a link containing the specified information, at least for the following tables:
- Oracle
- PostgreSQL
- DB2
- HSQLDB,
- MS SQL
- MySQL
Could not find a good consolidated and useful link for this over the past few days. Thank.
source
share