In The ‘select’ Statement What Is “group By”?

1.	In The ‘select’ Statement What Is “group By”?
Answer» Group by clause is USED to fetch the data from the table by the specified field ex.select COUNT (*) from emp table group by deptno where deptno = 1. It is used to FIND the number of employees present in the specified DEPARTMENT no.

Answer»

Group by clause is USED to fetch the data from the table by the specified field
ex.select COUNT (*) from emp table group by deptno where deptno = 1.
It is used to FIND the number of employees present in the specified DEPARTMENT no.

Discussion