Skip to content

Coder Tutorial

Menu
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • MySQL
  • JS
  • PL/SQL
  • Python
  • Java
  • Oracle
Home
PL/SQL
PL/SQL Group_ID

PL/SQL Group_ID

Oracle PL/SQL Group_ID Function

The Group_ID function assigns a number to each group resulting from a GROUP BY clause.
For each unique group will return 0. When a duplicated group is found, the group_id function will return a value >0.

Example:

Select sum(sal), deptno, comm, GROUP_ID() 
From emp
Where comm > 100
Group By deptno,
Rollup (deptno, comm);

Tutorials

  • PL/SQL Tutorial
  • PL/SQL Blocks
  • PL/SQL Variables
  • PL/SQL Control structures
  • PL/SQL Collections and Records
  • PL/SQL Cursors
  • PL/SQL Stored Procedures
  • PL/SQL Functions
  • PL/SQL Packages
  • PL/SQL Exception Handling
  • PL/SQL Triggers
  • PL/SQL If-Then-Else Statement
  • PL/SQL For Loop
  • PL/SQL While Loop
  • PL/SQL Case Statement
  • PL/SQL Varray
  • PL/SQL Nested Table
  • PL/SQL Indexed Arrays
  • PL/SQL Record
  • PL/SQL Examples
  • Oracle PL/SQL Functions
  • PL/SQL Interview Questions

Recent Posts

  • Java Polymorphism
  • Java Encapsulation
  • Java Abstraction
  • PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
  • PostgreSQL Column must appear in the GROUP BY clause
  • PostgreSQL Column specified more than once
  • PostgreSQL Create database, Alter database examples
  • PostgreSQL Create schema syntax, Alter schema
  • PostgreSQL Create database user, alter and drop username
  • PostgreSQL Alter table name. Modify column name
Coder Tutorial Copyright © 2025. | Privacy Policy
Back to Top ↑