i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example
empno ename mgr_id
1 john 3
2 paul 3
3 smith 1
4 kevin 1
5 stewart 2
result has to look like this
ename manager
john smith
paul smith
smith john
kevin john
stewart paul
can u plz help me out in this.....
- 8 Answers
- 10597 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to run sql statements with oracle sql developer?
What do you mean by stored procedures?
Do stored procedures prevent sql injection?
How delete a row in sql?
Why is %isopen always false for an implicit cursor?
how to get help information from the server? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
How to fix oracle error ora-00942: table or view does not exist
Why use subqueries instead of joins?
What is sql lookup?
What are functions in sql?
What is the location of pre_defined_functions.
What is difference between table and view?
What is sql partition?
How do I save a stored procedure?
