Find the employees who are managers

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

Manish Kumar 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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

forum