FIND THE EMPLOYEES WHO ARE MANAGERS

Sunil Singh

Total Post:45

Points:323
Posted by  Sunil Singh
 353  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. Manish Sahu

    Post:47

    Points:331
    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!