SELECE FIELD1,FIELD2

FROM TABLENAME

GROUP BY FIELD1,FIELD2;

THIS MIGHT WORK

change the varchar(20) to varchar(50) and try it ...... it may solve ur problem

SELECT E.empname as Employee, M.empname as Manager

FROM Employee E , Employee M

WHERE E.managerid = M.Empid

AND Dept='scott';

here your are splitting a...