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
- 9459 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 are the differences among rownum, rank and dense_rank? : Sql dba
Does sql backup shrink transaction log?
What do you understand by pl/sql records?
What is substitution variable?
Why is a trigger used?
What is the difference between in and between in sql?
Compare sql & pl/sql
How to read/write files from pl/sql?
What is cross join example?
What steps server process has to take to execute an update statement?
What are different joins used in sql?
what are ddl statements in mysql? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
What is memory optimized table?
What is mdb stand for?
