Write a query in SQL to find the number of employees are performing the duty of a manager
- 2021-09-08
- mhanasmh00489829403
- م98
الأجوبة
SELECT count(DISTINCT m.emp_id)
FROM employees w,
employees m
WHERE w.manager_id = m.emp_id ;
count ------- 6
(1 row)