|
This course examines the summarizing of query results into groups using the GROUP BY clause in Oracle9i SQL.
Objectives:
After completing this course, students will be able to:
- Explain how group functions work
- Use aggregate functions
- Use DISTINCT and ALL clauses
- Group and sort rows using the GROUP BY clause
- Use the HAVING clause to restrict data
- Use the ROLLUP, CUBE, and GROUPING SETS clauses
Topics:
- The GROUP BY clause and group functions
- Aggregate functions
- Grouping rows and sorting with GROUP BY
- Restricting Data
- Extending the GROUP BY clause
|
