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
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 are the purpose of Normalisation?
What are the types of containers in ssis?
what are the different stages of Report Processing?
Explain what is use of dbcc commands?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to return the top 5 rows from a select query in ms sql server?
What are rows and columns?
Can you explain different types of locks in sql server?
What are drilldown reports?
what's sql server? : Sql server database administration
What do we have to check in database testing?
What languages bi uses to achieve the goal?
What are the common performance issues in sql server?
How to apply cascading referential integrity in place of triggers?
Explain system functions or built-in functions? What are different types of system functions?