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
- 6200 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
Can you explain powershell included in sql server 2008?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Explain about unique identifier data type in sql server?
What are the different types of backups avaialabe in sql server 2005?
What is the difference between row_number and dense_rank?
How do I trace a query in sql server?
Differentiate between delete and truncate.
How many types of cursor type are there?
What type of locking occurs during the snapshot generation? : sql server replication
What are the restrictions while creating batches in sql server?
Explain what is scheduled job and how to create it?
What is ssrs?
Tell me when is the update_statistics command used?
Do comments need to go in a special place in sql server 2005?
Explain transaction server distributed transaction?
