sub-queries correlated-subquery synchronized-subquery
join inner-join
isolation transactions REPEATABLE-READ SERIALIZABLE phantom-read
NULL-values
MS-Access Oracle DROP-statement DROP-INDEX MySQL DB2 SQL-server
HAVING-clause GROUP-BY-clause aggregate-functions
WHERE-clause operators
Oracle NULL-values General-Functions NVL
FROM-clause optimization
COUNT-Function aggregate-functions NULL-values