select e.empname,m.ename mgrname from emp e,emp m where e.mgrid=m.empid;

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

Question Posted / nanne saheb c

4 Answers
8189 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

Please Help Members By Posting Answers For Below Questions

What is difference between nchar and nvarchar?

958

What is the starting oracle error number? What is meant by forward declaration in functions?

940

What is a procedure in pl sql?

1131

what are the join types in tsql? : Transact sql

983

How to call shell script from pl sql procedure?

1177

Are pl sql variables case sensitive?

1000

Does truncate free space?

948

What do you understand by exception handling in pl/sql?

966

How does an execution block start and end in pl sql?

901

What is example of database?

987

Is crud a cuss word?

975

How many clustered indexes can be created on a table?

1024

What is pessimistic concurrency control? : Transact sql

1025

What are the benefits of triggers?

1122

How do you truncate?

855