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
- 5935 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
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What are the types of database schema? : sql server analysis services, ssas
What are the reporting services components?
What is self join in sql server joins?
How would you add a section to a table?
What is ms sql server reporting services?
How to declare a cursor with "declare ... Cursor" in ms sql server?
what is a sub-report?
You want to implement the one-to-one relationship while designing tables. How would you do it?
what is blocking? : Sql server database administration
What are the different ways you can create databases in sql server?
What is dimension table? : sql server analysis services, ssas
What is wide table?
how can you attach more than 20 ldf files in sql server
How do I delete a sql server database?
