SQL GROUP BY Clause

Submitted by:Pitter Alderson

Date added:08 September, 2012

Category:SQL

SQL query to know total number of employee on each department.

Tags: group by clause

Code Snippet:

SELECT Dept,COUNT(Dept) as Total
FROM Employee_Table
GROUP BY Dept
 
 

Comments