NULL-values
sub-queries correlated-subquery synchronized-subquery
unique-key primary-key constraints
operators logical-operators
MySQL CASE-Function
isolation phantom-read transactions non-repeatable-reads range-locks
join inner-join
MySQL collation character-sets
NULL-values constraints NOT-NULL-constraint
TOP-clause SQL-server