CASE-Function
FROM-clause optimization
TOP-clause SQL-server
operators logical-operators
ORDER-BY-clause
unique-key primary-key constraints
SQL-Injection
HAVING-clause COUNT-Function aggregate-functions
sub-queries correlated-subquery synchronized-subquery
join inner-join
