hi i got the query.. 😛

select e1.empname as manager,e2.empname from man e1,man e2

where e1.empid=e2.managerid order by e1.managerid

Thanks

sabeer.M