Home
Oracle PL / SQL
Aggregate Functions
Analytical Functions
Char Functions
Constraints
Conversion Functions
Cursor
Data Type
Date Timezone
Hierarchical Query
Index
Insert Delete Update
Large Objects
Numeric Math Functions
Object Oriented Database
PL SQL
Regular Expressions
Report Column Page
Result Set
Select Query
Sequence
SQL Plus
Stored Procedure Function
Subquery
System Packages
System Tables Views
Table
Table Joins
Trigger
User Previliege
View
XML
Rollup « Analytical Functions « Oracle PL / SQL
Oracle PL / SQL
Analytical Functions
Rollup
1.
Rollup: give the sum on the aggregate; it is used as an add-on to the GROUP BY clause
2.
With ROLLUP and ROW_NUMBER added
3.
The ROLLUP clause extends GROUP BY to return a row containing a subtotal for each group along with a total for all groups
4.
Changing the Position of Columns Passed to ROLLUP
5.
Passing Multiple Columns to ROLLUP: groups the rows into blocks with the same column values
6.
Using AVG with ROLLUP
7.
Rollup function in group by clause
8.
ROLLUP and RANK() to get the sales rankings by product type ID
9.
Demonstrate a partial rollup
10.
Count employees, group by ROLLUP(department no, job title)
11.
group by ROLLUP(department no, job title)
12.
group by rollup