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
- 10602 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is java sql connection?
What are the advantages of pl sql?
What is right join sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is example of database?
How do you declare a user-defined exception?
What are the different sql commands?
What does the base_object_type column shows in the user.triggers data dictionary view?
explain mysql aggregate functions. : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
Can we perform dml in function?
How do you exit in sql?
What is pivot table in sql?
explain advantages of innodb over myisam. : Sql dba
what is single byte over head in oracle..?
