Comparison of Relational Database Management Systems - Database Capabilities

Database Capabilities

Union Intersect Except Inner joins Outer joins Inner selects Merge joins Blobs and Clobs Common Table Expressions Windowing Functions Parallel Query
4th Dimension Yes Yes Yes Yes Yes No No Yes ? ? ?
ADABAS Yes ? ? ? ? ? ? ? ? ? ?
Adaptive Server Enterprise Yes ? ? Yes Yes Yes Yes Yes ? ? Yes
Advantage Database Server Yes No No Yes Yes Yes Yes Yes ? No ?
Altibase Yes Yes Yes, via MINUS Yes Yes Yes Yes Yes No No No
Apache Derby Yes Yes Yes Yes Yes ? ? Yes No No ?
CUBRID Yes Yes Yes Yes Yes Yes Yes Yes No No ?
Drizzle Yes No No Yes Yes Yes No Yes No No No
DB2 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Empress Embedded Database Yes Yes Yes Yes Yes Yes Yes Yes ? ? ?
Firebird Yes ? ? Yes Yes Yes Yes Yes Yes Yes ?
HSQLDB Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes
H2 Yes Yes Yes Yes Yes Yes No Yes experimental No ?
Informix Dynamic Server Yes ? Yes, via MINUS Yes Yes Yes Yes Yes Yes ? Yes
Ingres Yes No No Yes Yes Yes Yes Yes No No ?
InterBase Yes ? ? Yes Yes ? ? Yes ? ? ?
Linter SQL RDBMS Yes Yes Yes Yes Yes Yes Yes Yes No Yes ?
LucidDB Yes Yes Yes Yes Yes Yes Yes No ? ? ?
MaxDB Yes ? ? Yes Yes Yes No Yes ? ? ?
Microsoft Access (JET) Yes No No Yes Yes Yes No Yes No No ?
Microsoft Visual Foxpro Yes ? ? Yes Yes Yes ? Yes ? ? ?
Microsoft SQL Server Yes Yes (2005 and beyond) Yes (2005 and beyond) Yes Yes Yes Yes Yes Yes Yes Yes
Microsoft SQL Server Compact (Embedded Database) Yes No No Yes Yes ? No Yes No No ?
MonetDB/SQL ? ? ? ? ? ? ? ? ? ? ?
MySQL Yes No No Yes Yes Yes No Yes No No No
OpenBase SQL No No No Yes Yes Yes Yes Yes ? ? ?
Oracle Yes Yes Yes, via MINUS Yes Yes Yes Yes Yes Yes 1 Yes Yes
Oracle Rdb Yes Yes Yes Yes Yes Yes Yes Yes ? ? ?
OpenLink Virtuoso Yes ? ? Yes Yes Yes ? Yes ? ? ?
Polyhedra DBMS Yes Yes Yes Yes No ? ? Yes ? ? ?
PostgreSQL Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No
RDM Embedded No No No Yes Yes No No Yes No No No
RDM Server Yes No No Yes Yes Yes No Yes No No No
ScimoreDB Yes ? ? Yes LEFT only Yes Yes Yes ? ? ?
SmallSQL ? ? ? ? ? ? ? ? ? ? ?
SQL Anywhere Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
SQLite Yes Yes Yes Yes LEFT only Yes No Yes No No No
Teradata Yes Yes Yes Yes Yes Yes Yes Yes No Yes Yes
UniVerse Yes Yes Yes Yes Yes Yes Yes No No No ?
Xeround Cloud Database Yes No No Yes Yes Yes No Yes No No No
Union Intersect Except Inner joins Outer joins Inner selects Merge joins Blobs and Clobs Common Table Expressions Windowing Functions Parallel Query

Note (1): Recursive CTEs introduced in 11gR2 supersedes similar construct called CONNECT BY

Read more about this topic:  Comparison Of Relational Database Management Systems

Famous quotes containing the word capabilities:

    “I maintain that I have been a Negro three times—a Negro baby, a Negro girl and a Negro woman. Still, if you have received no clear cut impression of what the Negro in America is like, then you are in the same place with me. There is no The Negro here. Our lives are so diversified, internal attitudes so varied, appearances and capabilities so different, that there is no possible classification so catholic that it will cover us all, except My people! My people!”
    —Zora Neale Hurston (1891–1960)