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

Scalability, Availability, Integration with internet, etc.)?

2878

Is it true, that there is no difference between a rule and a check constraint?

1055

how many bits ip address consist of? : Sql server database administration

898

How to replace null values in expressions using isnull()?

1100

what is sql server? : Sql server database administration

986

How to generate create procedure script on an existing stored procedure?

1009

What are the properties and different types of sub-queries?

1011

What are the types of normalization?

1031

how many layers of tcp/ip protocol combined of? : Sql server database administration

997

What is compound operators?

1057

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362

How to make remote connection in database?

1005

what is a transaction and what are acid properties? : Sql server database administration

1024

What are cursors in ms sql server?

1178

How can sql server instances be hidden? : sql server security

1146