Summarizing, grouping, and sorting query results


Summarizing query results using aggregate functions
The GROUP BY clause: Organizing query results into groups
The HAVING clause: selecting groups of data
The ORDER BY clause: sorting query results
Performing set operations on query results with UNION, INTERSECT, and EXCEPT
Standards and compatibility