join cross-join inner-join
unique-key primary-key constraints
ROWNUM Oracle
sub-queries correlated-subquery synchronized-subquery
NVL NULL-values COALESCE NULLIF General-Functions NV2
MySQL collation character-sets
WHERE-clause DELETE-statement
join inner-join
Oracle MS-Access DROP-statement MySQL DROP-INDEX DB2 SQL-server
ORDER-BY-clause HAVING-clause SELECT-clause order-of-operations queries FROM-clause WHERE-clause GROUP-BY-clause