Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table like this
Eno ename
1 a
2 b
3 c
i want to display ename and bossname from table
hint boss is also an employee
- 3 Answers
- 6096 Views
- NIIT, I also Faced
- E-Mail Answers
Answer Posted / sonia sharma
/---- You need one more column to view manager of each emp
suppose Mno is the column which contains corresponding Eno
as manager id--
select emp.ename , mgr.ename from empTable as emp
inner join empTable as mgr on emp.Mno = mgr.Eno
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Write a query for primary key constraint with identity key word?
What are rest-style architecture's?
Why are you getting errors when creating a new odbc dsn?
How to make a remote connection in a database?
What is the cartesian product of the table?
What is the distinction amongst delete and truncate?
How do I clean up sql server transaction log?
What do you mean by collation recursive stored procedure?
How to check parameter value in stored procedure sql server?
How do I debug a stored procedure in sql server?
How to specify the collation for a character data type in ms sql server?
What are the essential components of sql server service broker?
What stored by the tempdb ? : sql server database administration
What are the characteristics of modern DBMS?
Explain microsoft sql server functions?
