Guest kay112 Posted May 4, 2006 Share Posted May 4, 2006 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 More sharing options...
ray Posted May 5, 2006 Share Posted May 5, 2006 why did you make emp_mentor_id a string?change it to numeric and then just order by emp_mentor_id Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now