Chapter 7. Groups and Summaries (GROUP BY)

Terms You Need to Understand

  • ✓ The GROUP BY clause

  • ✓ Grouping functions

  • ✓ Aggregation functions

  • ✓ Analytical functions

  • ✓ The HAVING clause

  • ✓ Groups and Summaries (GROUP BY) The ROLLUP clause

  • ✓ Groups and Summaries (GROUP BY) The CUBE clause

  • ✓ Groups and Summaries (GROUP BY) GROUPING SETS clauses

  • ✓ The OVER clause

  • ✓ OLAP

Concepts You Need to Master

  • ✓ SELECT statement sequence of WHERE, GROUP BY, and ORDER BY clauses

  • ✓ DISTINCT versus ALL

  • ✓ The difference between aggregation and analytical functions

  • ✓ Filtering using ...

Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial