In Oracle GROUP BY Clause helps to group the same values present in the table to provide a concise result.
Syntax
Select Column from Table_name
GROUP BY Column;
The Column in the above syntax is the name of the column containing values that need to be summarised.
Example: How to work with GROUP BY Clause?
You have a database of Students of different sections, to know the summary of section present in the database we can use GROUP BY Clause. Refer to the Children table below:
Now, to apply Group By follow the code below:
select Section from Children
group by Section;
OUTPUT:
Example: How to use aggregate functions with GROUP BY Clause?
Let's consider a case wherein we have Student data of different sections along with marks of Students. So to find the highest marks for every section we can use the GROUP BY Clause:
Select Section, MAX(marks) from Children
group by Section;
OUTPUT:
From the above output, we got to know the highest scoring of students from each section A, B, and C.