forum

Home / DeveloperSection / Forums / Find the employees who are managers

Find the employees who are managers

Sunil Singh 1207 26-Nov-2017

I want to find that record who is managers for an employees. My database table is like

Can anyone help me to solve this problem..

Thanks in advance

database sql server

Updated on 27-Nov-2017

Can you answer this question?

Answer

27-Nov-2017

Try this

SELECT DISTINCT e.emp_id AS 'mng_id', e.emp_name AS 'mng_name'
FROM employees e, employees m WHERE e.emp_id = m.mng_id