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

How to enter date and time literals in ms sql server?

1067

What stored procedure can you use to display the current processes?

947

What does the not null constraint do?

1180

What are the requirements to use odbc connections in php scripts?

1159

Describe the left outer join & right outer join. : sql server database administration

1038

What are the different types of join?

1241

How to use wildcard characters in like operations in ms sql server?

1191

What is the difference RDBMS and Graph Database?

1094

What is difference between inner join and join?

1096

what is raid and what are different types of raid configurations? : Sql server database administration

1105

How to run sql server 2005 books online on your local system?

1005

Explain the flow of creating a cube? : sql server analysis services, ssas

1103

How to create function with parameter in sql server?

1158

What program is used to store the data source file?

1007

How to query multiple tables jointly?

1044