Loading

How to get the count of records

Murali krishna Ande

12y1.9k

Hi,

My table of records are like below

and I need to show them like below.

Can somebody help on this with the query,

--Thanks in advance,

Murali krishna

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

KISHORE B12y ago
Hi Murali, Select Department,Count(EMPID) as EMP_Count from TableName Group by Department.
0
Bagesh kumar singh12y ago
Select Department,COUNT(EMPID) As 'Number Of Employee' from Table group By Department
0
Sandeep Singh Shekhawat12y ago

SELECT Department, COUNT(DEPARTMENT) from DepertamentTable

Group by DEPARTMENT

0
Hanook12y ago
select Department, COUNT(EMPID) AS EmpCnt
FROM TableName
GROUP BY Department
0