forum

home / developersection / forums / find the employees who are managers

Find the employees who are managers

Sunil Singh 1432 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

Sunil Singh

Other

Message

Can you answer this question?

1 Answers

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

MindStick Training