Find the employees who are managers

Total Post:45

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

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.