GROUP_ID function in Oracle

GROUP_ID is an advanced function that the Oracle database supports. It is used to assign a number to each group resulting from a GROUP BY clause. The GROUP_ID function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax:

SELECT column1, column2, ... column_n, GROUP_ID()
FROM tables
WHERE conditions
GROUP BY column1, column2, ... column_n;

Example:

SELECT SUM(marks), class, extra_marks, GROUP_ID()
FROM students
WHERE extra_marks > 10
GROUP BY class,
ROLLUP (class, extra_marks);

Explanation: The GROUP_ID function will return 0, for each unique group in the result set. It will return a value greater than 0, if a duplicated group is found.

Please follow and like us:
Content Protection by DMCA.com