Find the employees who are managers

Total Post:45

Points:323
 500  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

NEWSLETTER

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