GROUPING « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. GROUPING
1.GROUPING() returns 0 for the rows that have non-null values, and 1 for the last row that has a null value
2.GROUPING(x): either zero or one
3.Using DECODE() to Convert the Returned Value from GROUPING()
4.Using DECODE() and GROUPING() to Convert Multiple Column Values
5.Using GROUPING() with CUBE
6.Demonstrate GROUPING in the HAVING clause
7.having grouping(c.class_desc) = 1