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
- 7582 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
Is join an inner join?
explain the delete statements in sql
What is the difference between sql and mysql?
What can sql server reporting services do?
What does over partition by mean in sql?
what is the functionality of the function htmlentities? : Sql dba
Explain exception handling in pl/sql?
How to use distinct and count in sql query? Explain
What is the difference between pl and sql?
How to add a column ‘salary’ to a table employee_details?
How many clustered indexes can you have?
What is a unique key and primary key and foreign key?
How do I copy a table in sql?
What is auto increment?
What is crud diagram?
