Aggregating and Grouping

Lecture

• Aggregating and Grouping
• The Aggregate functions
• SUM, COUNT, AVG, MIN, MAX
• The GROUP BY clause
• The "Golden Rule"
• The HAVING clause
• Finding Duplicate Records
• GROUP BY with the ROLLUP option
• The ORDER BY clause
• Pivoting rows into columns