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.....
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
how to check server status with 'mysqladmin'? : Sql dba
What is nested table in pl sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is optimistic concurrency control? : Transact sql
Are stored procedures faster than queries?
What is set serveroutput on?
How can I tell if sql is running?
Which is faster joins or subqueries?
What are the two types of periodical indexes?
Describe sql comments?
What is sqlerrd?
What is the source code of a program?
how to use in conditions? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How do I run a pl sql program?