FIND THE EMPLOYEES WHO ARE MANAGERS

Total Post:45

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

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


  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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!