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
8375 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 a natural join?

1074

What is the difference between sql and mysql?

1119

What is a unique constraint?

1078

What is difference between stored procedure and trigger?

1169

What are primary key and foreign key and how they work?

978

what is a relationship and what are they? : Sql dba

1101

write an sql query to find names of employee start with 'a'? : Sql dba

1027

Can we have two clustered index on a table?

1025

How to execute a stored procedure?

1092

What is sql rowcount?

1023

how to create a new table in mysql? : Sql dba

986

how do you know the version of your mysql server? : Sql dba

1004

how to dump a table to a file with 'mysqldump'? : Sql dba

1036

How to connect a sql*plus session to an oracle server?

1128

what is an index? : Sql dba

998