GROUPING_ID « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. GROUPING_ID
1.An Example Query that Illustrates the Use of GROUPING_ID()
2.One useful application of GROUPING_ID() is to filter rows using a HAVING clause
3.You can use the GROUP_ID() function to remove duplicate rows returned by a GROUP BY clause
4.Eliminate duplicate rows using a HAVING clause that only allows rows whose GROUP_ID() is 0