Definition to groupfunction in dbms

Answer 1

The GROUP BY clause in a query is used to display output that is grouped by a particular criteria. Let us say the management wants to find out the number of employees in each of its department then they can use a below query.

SELECT department, count(*) as count FROM employee_master GROUP BY department

The output could be like:

Department count

IT Department 1040

Human Resources 55

Sales Desk 135

and so on.