Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
25 / 108
A table contains data like this
Employee_type No_of_Employees
--------------------- --------------
A 10
B 20
C 30
B 25
A 40
D 30
Write a query to print total no. of employees in each employee type.
Answer:
SELECT SUM(No_of_Employees) as TotalEmp, Employee_type from EmpTable Group by Employee_type
Asked In ::
Kiran Jawale
16 Sep, 2021 10:06 PM
SELECT SUM(No_of_Employees) as TotalEmp, Employee_type from EmpTable Group by Employee_type