i have a table like this Eno ename 1 a 2 b 3 c i want to disp

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

3 Answers
5996 Views
NIIT, I also Faced
E-Mail Answers

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)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is similarity and difference between truncate and delete in sql?

0 Answers

How to use go command in "sqlcmd"?

0 Answers

which one will take 1st priority in case of insert statement and select statement???

2 Answers HCL,

Can group by and orderby be used together?

0 Answers

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers RND Soft, Wipro,

How to create a local temporary stored procedure?

0 Answers

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers

Explain the properties of a relational table?

0 Answers

Can a database be shrunk to 0 bytes, if not, why?

0 Answers

Can we call future method from queueable?

0 Answers

what happens on checkpoint? : Sql server database administration

0 Answers

What are user-defined functions (udfs) in sql server?

0 Answers

For more SQL Server Interview Questions Click Here