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 is server-level principal?

102

What is the maximum size of sql server database?

513

What is the meaning of resultset type_scroll_insensitive?

565

Why should you use or avoid select * statements?

580

What is the purpose of floor function?

543

How to use go command in "sqlcmd"?

649

Find first and last day of current month in sql server

599

What is tempdb in sql server?

521

How to execute stored procedure and set temp table in sql server?

560

What is the primary use of the model database?

628

How to get a list of columns in a view using "sys.columns" in ms sql server?

521

Explain the microsoft sql server delete command? : SQL Server Architecture

587

What are xml indexes?

532

If any stored procedure is encrypted, then can we see its definition in activity monitor?

553

Explain filestream storage of sql server 2008?

520