Interested to Buy Any Domain ? << Click Here >> for more details...
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.....
- 8 Answers
- 12309 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
How do you clear the screen in sql?
Why is normalization important?
What is the difference between inner join and natural join?
What is the purpose of a sql?
What is partition by in sql?
What is the difference between a primary key and a unique key?
What are the different types of database management systems?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How do I view a table in sql?
What is rank function in sql?
How many databases can sql express handle?
What is the largest value that can be stored in a byte data field?
How do you create a unique index?
Why having clause is used in sql?
What is a sql profiler?
