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
- 6085 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
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How do I find my localdb version?
Which are the third-party tools used in sql server and why would you use them?
What is shrink log file?
What is user-defined scalar function?
What is a fan-out query in SQL Azure?
Is sql different from sql server?
Find first and last day of current month in sql server
What is sql server english query?
Do you know what are the ways available in sql server to execute sql statements?
How can we remove orphan records from a table?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How to delete an existing database user?
What are sp_configure commands and set commands?
Do you know what is similarity and difference between truncate and delete in sql?
