Split this page into multiple pages
Keep in Mind:
Aggregate functions (such as SUM, AVG, COUNT, COUNT(*), MAX, and MIN) generate summary values in query result sets.
The GROUP BY clause is used to produce aggregate values for each row in the result set.
The UNION operator allows you to combine the results of two or more SELECT statements into a single result set.
The CASE function is used to evaluate several conditions and return a single value for each condition.
Basic query clauses: Select list FROM clause WHERE clause ORDER BY clause JOIN clauses
Note
Warning!