How to get the count of records

Question

Hi My table of records are like below EMPID Name Department 1 AAAAA 1 2 BBBBB 2 3 CCCCC 2 4 DDDDD 3 5 EEEEEE 3 and I need to show them like below. Department Count 1 1 2 2 3 2 Can somebody help on this with the query --Thanks in advance Murali krishna

Bagesh kumar singh · Answer

Select DepartmentCOUNT(EMPID) As 'Number Of Employee' from Table group By Department

KISHORE B · Answer

Hi Murali Select DepartmentCount(EMPID) as EMP_Count from TableName Group by Department.

Sandeep Singh Shekhawat · Answer

14.00 SELECT Department  COUNT ( DEPARTMENT ) from DepertamentTable Group by DEPARTMENT Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:Times New Roman;mso-bidi-theme-font:minor-bidi;}

Hanook · Answer

select Department COUNT(EMPID) AS EmpCnt FROM TableName GROUP BY Department