Cube of the Oracle grouping function

Feature Description:

The first is to do a no-field aggregation, and then to aggregate each field in turn

To create a table:

View Code

Insert test data:

View Code

ROLLUP:

Select t.classid,t.studentname,SumfromGroup by

Query Result:

Cube:

Select t.classid,t.studentname,SumfromGroup by

Query Result:

More than 8 rows of records relative to Collup:

Rollup (t.classid,t.studentname): Grouped columns of statistics include (), (ClassID), and (Classid,studentname)

Cube (t.classid,t.studentname): Grouped columns of statistics include (), (ClassID), (Studentname), and (Classid,studentname)

Cube of the Oracle grouping function