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
- 11926 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
Explain the difference between 'between' & 'and' operators in sql
How to write a query to show the details of a student from students table whose
What is the difference between clustered and non-clustered indexes?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is a primary key called that is made up of more than one field?
What is a crud api?
Can we write dml inside a function in sql server?
What are the properties of a transaction?
how to concatenate two character strings? : Sql dba
What does seeding a database mean?
how to use regular expression in pattern match conditions? : Sql dba
What is parallel hint?
What is parameter substitution in sql?
How long it takes to learn pl sql?
how to do backup entire database? : Transact sql
