ROLLUP « Analytical Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Analytical Functions
  3. ROLLUP
16.24.ROLLUP
16.24.1.Using the ROLLUP Clause
16.24.2.Passing Multiple Columns to ROLLUP
16.24.3.Changing the Position of Columns Passed to ROLLUP
16.24.4.Uses AVG() with ROLLUP
16.24.5.Using a Column Multiple Times in a GROUP BY Clause
16.24.6.The ROLLUP function was provided to conveniently give the sum on the aggregate.
16.24.7.A two-dimensional grouping with ROLLUP
16.24.8.A SUM using ROLLUP.
16.24.9.Rollup with two columns








16.24.10.Case with grouping and rollup
16.24.11.Count employees, group by ROLLUP(department no, job title)
16.24.12.group by ROLLUP(department no, job title)