self join

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

Question Posted / saket

Answer Posted / saket

self join

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are commit and rollback in sql?

1097

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

908

How can you insert values in multiple rows using one Insert statement?

1077

What is a database in ms sql server?

1037

What are the Advantages of using CTE in sql server?

1095

what type of index will get created after executing the above statement? : Sql server database administration

961

What is data compression?

973

What are trace flags and mention a few common trace flags used with sql server?

1070

What are the benefits of filtered indexes?

1022

Explain triggers?

987

What is check constraint in sql server?

980

Describe triggers features and limitations?

966

What options are available to audit login activity? : sql server security

1130

explain different types of constraints? : Sql server database administration

941

what is dbcc? : Sql server database administration

1012