self join will accomplish this task.try below query select a.ename,b.ena

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example
empno ename mgr_id
1 john 3
2 paul 3
3 smith 1
4 kevin 1
5 stewart 2

result has to look like this

ename manager
john smith
paul smith
smith john
kevin john
stewart paul

can u plz help me out in this.....

Question Posted / john bershan

8 Answers
12256 Views
I also Faced
E-Mail Answers

Answer Posted / john bershan

self join will accomplish this task.try below query

select a.ename,b.ename as manager from emp a,emp b
where a.empno = b.mgrid;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to increment dates by 1 in mysql? : Sql dba

977

What is the sql case statement?

1001

What are the parameter modes supported by pl/sql?

1108

is mysql query is case sensitive? : Sql dba

1100

What is sql performance tuning?

917

What is right join in sql?

1089

What is sql character function?

1078

Is sql similar to python?

969

Why procedure is used in sql?

1036

What are sql constraints?

1172

What is sql exception?

972

What is sqlca in db2?

959

What does inner join mean?

1165

What is autocommit sql?

992

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010