Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / klbaiju

Answers were Sorted based on User's Feedback



i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossna..

Answer / saket

self join

Is This Answer Correct ?    6 Yes 0 No

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossna..

Answer / sonia sharma

/---- You need one more column to view manager of each emp
suppose Mno is the column which contains corresponding Eno
as manager id--

select emp.ename , mgr.ename from empTable as emp
inner join empTable as mgr on emp.Mno = mgr.Eno

Is This Answer Correct ?    3 Yes 1 No

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossna..

Answer / mahesh (ezeesoft)

/---- You need one more column to view manager of each emp
suppose Mno is the column which contains corresponding Eno
as manager id--

select emp.ename , mgr.ename from empTable as emp
SELF JOIN empTable as mgr on emp.Mno = mgr.Eno

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to find out the list schema name and table name for the database?

0 Answers  

From where can you change the default port?

3 Answers  

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

How to recompile stored procedure at run time?

0 Answers  

Explain the concepts and capabilities of sql server?

0 Answers  

What is a materialized view?

3 Answers  

How many ways to create table-valued functions?

0 Answers  

List the ways in which dynamic sql can be executed?

0 Answers  

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

what are the limitations of parameters in a storedprocedure

1 Answers  

What is data source in connection string?

0 Answers  

Tell me extended events in sql server 2008?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories