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
- 10601 Views
- I also Faced
- E-Mail Answers
Answer Posted / adil
I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many sql databases can you have on one server?
what is query cache in mysql? : Sql dba
Are sql database names case sensitive?
how to get a list of columns in an existing table? : Sql dba
how to shutdown mysql server? : Sql dba
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Write a query to display the current date in sql?
What does stand for in sql?
What is meant by user defined function?
Can we commit inside a trigger?
What programs use sql?
Explain the advantages and disadvantages of stored procedure?
Explain the commit statement.
what are the differences between char and varchar? : Sql dba
Does truncate remove indexes?
