Answer / praveen h

I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno

Answer / rajesh venati

select e.ename as employee_name,m.ename as manager_name from
emp e, emp m where e.mgr_id=m.empno;

Answer / adil

I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno

Answer / cbigmudre

select a.ename, b.enanme as manager
from emp as a, emp as b
where a.empno = b.mgr_id

Answer / karthik

select e1.empno,e1.ename EmpName,e2.ename MgrName from emp e1,emp e2
where e1.mgr_id=e2.ename(+);

select e1.empno,e1.ename EmpName,e2.ename MgrName
from emp e1 left outer join emp e2
where e1.mgr_id=e2.ename;

Answer / sudhan

select e1.ename EmpName,e2.ename MgrName from emp e1,emp e2
where e1.mgr_id=e2.ename;

Answer / john bershan

self join will accomplish this task.try below query

select a.ename,b.ename as manager from emp a,emp b
where a.empno = b.mgrid;

Answer / monika

select empno,ename
from emp
start with mgr_id is null
connect by prior empno=mgr_id;

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

what is index? : Sql dba

0 Answers  

How can I pass the inner procedure value to outer procedure ?

2 Answers  

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

What is the difference between in and between in sql?

0 Answers  

How does a covering index work?

0 Answers  

What are stored procedures in mysql?

0 Answers  

Why having clause is used in sql?

0 Answers  

What is the difference between delete and truncate statement in sql?

0 Answers  

Is sql database free?

0 Answers  

What are the string functions in sql?

0 Answers  

explain primary keys and auto increment fields in mysql : sql dba

0 Answers