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

Can group by be used without aggregate functions?

918

In how many ways you can invoke ssrs reports?

139

Explain what is use of dbcc commands?

1056

What is the difference between count () and rowcount ()?

1024

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1204

What are transactions in sql?

1060

What is the difference between stored procedure and functions?

1129

Explain the functionalities that views support?

1112

How do I find information about the install locations for the various instances running on a computer?

1078

What is the purpose of grouping data in a report?

966

Explain what is raid and what are different types of raid levels?

1023

What is check constraint in sql server?

1002

How to view existing indexes on an given table using sys.indexes?

1090

What are the five characteristics of good data?

914

Explain aggregate functions?

1079