CBSE Class 12 Computer Science Question 83 of 91

Grouping Records, Joins in SQL — Question 18

Back to all questions
18
Question

Question 17

Find out number of employees having "Manager" as Job.

Answer
SELECT COUNT(*) AS NumManagers
FROM EmpSalary
WHERE Designation = 'Manager';
Output
+-------------+
| NumManagers |
+-------------+
|           3 |
+-------------+