Find the employees who are managers

Total Post:45

Points:323
 540  View(s)
Ratings:
Rate this:

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

Find the employees who are managers

Can anyone help me to solve this problem..  

Thanks in advance


  1. Post:52

    Points:366
    Re: Find the employees who are managers

    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
    


      Modified On Nov-27-2017 11:11:57 PM

Answer