Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 75 of 90

Querying Using SQL — Question 15

Back to all questions
15
Question

Question 15

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

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