Hi irshad1231,
Refer below sample query.
SQL
DECLARE @Test AS TABLE(emp_id INT,Department VARCHAR(10),Datetime DATETIME)
INSERT INTO @Test VALUES(1,'mm1','2019/02/24')
INSERT INTO @Test VALUES(2,'mm1','2019/02/24')
INSERT INTO @Test VALUES(3,'mm1','2019/02/24')
INSERT INTO @Test VALUES(4,'mm1','2019/03/05')
INSERT INTO @Test VALUES(1,'mm2','2019/02/24')
INSERT INTO @Test VALUES(2,'mm2','2019/02/24')
INSERT INTO @Test VALUES(3,'mm2','2019/02/24')
INSERT INTO @Test VALUES(4,'mm2','2019/03/05')
INSERT INTO @Test VALUES(1,'mm3','2019/02/24')
INSERT INTO @Test VALUES(2,'mm3','2019/02/24')
INSERT INTO @Test VALUES(3,'mm3','2019/02/24')
INSERT INTO @Test VALUES(4,'mm3','2019/03/05')
SELECT t1.Department, count(emp_id) AS 'TOTALValue',cast((count(emp_id)/(total * 1.000)) AS float)*100 as Percentage
FROM @Test AS t1
JOIN (SELECT Department, count(emp_id) AS total
FROM @Test
GROUP BY Department
) AS t2
ON t1.Department = t2.Department
GROUP BY t1.Department, total
Output
| Department |
TOTALValue |
Percentage |
| mm1 |
4 |
100 |
| mm2 |
4 |
100 |
| mm3 |
4 |
100 |
