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
- 7038 Views
- I also Faced
- E-Mail Answers
Answer Posted / nanne saheb c
select e.empname,m.ename mgrname from emp e,emp m
where e.mgrid=m.empid;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between 'between' & 'and' operators in sql
What trigger means?
What is a pragma statement?
How do you bind variables in pl sql?
How can get second highest salary in sql?
How to change sql*plus system settings?
Is pl sql still used?
What is trigger and stored procedure in sql?
Why sql query is slow?
What is the difference between explicit and implicit cursors in oracle?
what is collation? : Sql dba
What is the use of triggers?
What is a data definition language?
What are the types of index in sql?
What is a procedure in pl sql?
