| A | B |
|---|
| Having | used to specify which groups are to be displayed; restricts groups that do not meet group criteria |
| Group By | divides the rows in a table into a group |
| Rollup | used to create subtotals that roll up from the most detailed level to a grand total, following a grouping list specified in the clause |
| Cube | an extension to the group by clause like rollup that produces cross tabulation reports |
| Group Sets | used to specify multiple groupings of data |
| Grouping Function | used to return a value for an aggregated row and another value for a non aggregated row |
| Set Operators | used to combine results into a singleresult from multiple select statements |
| Union | operator that returns all rows from both tables and eliminates duplicates |
| Union All | operator that returns all rows from both tables; including duplicates |
| Intersect | operator that returns rows common to both tables |
| Minus | operator that returns rows that are unique to each table |
| To_Char(null) | columns that were made up to match queries in another table not in both tables |
