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

Please explain what is “asynchronous” communication in sql server service broker?

880

How to add more data to the testing table in ms sql server?

1002

What is replication with database mirroring? : sql server database administration

988

Does the unique constraint create an index?

991

What do you mean by sql server 2005 express management tools?

1253

What is the difference between TRUNCATE and DROP?

1067

Differentiate between a primary key and a unique key.

1001

What languages bi uses to achieve the goal?

947

How to insert a new row into a table with "insert into" statements in ms sql server?

915

What are the new security features added in sql server 2012? : sql server security

949

What is the difference between ddl and dml?

1005

What are different types of constraints?

877

What is ssrs?

117

Do you think BCNF is better than 2NF & 3NF? Why?

1226

Explain SSRS Architecture?

185