HAVING-clause COUNT-Function aggregate-functions
isolation non-repeatable-reads phantom-read transactions range-locks
CASE-Function
join inner-join
constraints CHECK-constraint
SELECT-clause INSERT-statement
TRUNCATE-TABLE
collation binary-collation character-sets case-insensitive-collation
join cross-join inner-join
sub-queries