Tuesday, June 3, 2014

Write a Query to get employee name id manager name using self join




select a.id,a.name as employee,b.name as manager from empmgr a,empmgr b where a.mgr=b.id