Jump to content

correlated subquries

Guest kay112

Recommended Posts

Guest kay112

hi...i have a employee table with fields - emp_id, emp_name, emp_mentor_idData is as below... EMP ID EMP NAME MENTOR ID006 Malley 018 009 Lopez 021 010 Angelo 004 012 Rodriguez 018 017 Beck 011 019 Xave 013 How do i find out who is mentoring the highest number of employees? i should get EMP ID EMP NAME MENTOR ID006 Malley 018 012 Rodriguez 018i been trying to get tat output but with no success... can someone help me with this.. thank you... ps. i'm using isql plus...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...