Which RDBMS has the richest super-set of ANSI-SQL? Which RDBMS has the richest super-set of ANSI-SQL? oracle oracle

Which RDBMS has the richest super-set of ANSI-SQL?


It's hard to tell what is "richest". All systems have some proprietary things which the other systems don't support, including, but not limited to:

  • MODEL clause in Oracle
  • CROSS APPLY in SQL Server
  • DISTINCT ON in PostgreSQL
  • ON DUPLICATE KEY UPDATE in MySQL


DB2 has a complete Java virtual machine available for server side processing stored procedures, you don't get much more "complete" than that.

CouchDB uses JavaScript, can't get much more flexible and complete that that either.