O'Reilly logo

Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) by Gavin Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required