Hi all,
i have a table as follows
empid empname mgrid deptid
1 a 3 4
2 b 1 5
3 c 2 3
4 d 3 6
5 e 4 7
i want the output as
empname mgrname
a c
b a
c b
d c
e d
- 4 Answers
- 7583 Views
- I also Faced
- E-Mail Answers
Answer Posted / gunturajesh
select a.empname empname,b.empname mgrname from emp a,emp b
where a.mgrid=b.empid
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
What are the key differences between SQL and PL SQL?
Can we commit in trigger?
Explain table and field in sql?
How do you update a table in sql?
What can I use instead of union in sql?
How can triggers be used for the table auditing?
What is partition in sql query?
Can we use threading in pl/sql?
difference between anonymous blocks and sub-programs.
What is mutating table error?
What is pl sql code?
Does sql*plus have a pl/sql engine?
What is the difference between delete and truncate commands?
What are the different types of database management systems?
What is numeric function sql?
