select a.ename,b.ename from emp a, emp b where a.empno=7698 and b.empno=a.mgr;
This Query for selecting the particular Emp name & Manager name for the given emp no
Type: Posts; User: uday_son1983; Keyword(s):
select a.ename,b.ename from emp a, emp b where a.empno=7698 and b.empno=a.mgr;
This Query for selecting the particular Emp name & Manager name for the given emp no
select a.ename,b.ename from emp where emp a, emp b where a.empno=b.mgr;
U can is this query to get the result manager name and emp name in a single query