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
8333 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

Explain the the update statement in sql?

1015

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1110

Why do we need unique key in a table?

942

What is a sql driver?

985

what is sql? : Sql dba

1002

How do I find duplicates in a single column in sql?

997

What is pl/sql language case sensitive?

1105

What are the various levels of constraints?

1114

How to read/write files from pl/sql?

1023

What are dml commands?

1002

What is row_number () in sql?

964

explain about mysql and its features. : Sql dba

1002

What is trigger point?

977

What is nvarchar in sql?

916

What are the possible values that can be stored in a boolean data field?

984