select emp.ename from employee emp1 inner join employee emp on emp1.mid=

table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output

Question Posted / samba shiva reddy . m

7 Answers
10369 Views
I also Faced
E-Mail Answers

Answer Posted / samba shiva reddy . m

select emp.ename from employee emp1
inner join employee emp
on emp1.mid=emp.eid
where emp1.eid=102

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about Views?

1072

What are the restrictions that views have to follow? : SQL Server Architecture

1004

How to declare a cursor with "declare ... Cursor" in ms sql server?

1049

Explain what is log shipping?

1140

What are the advantages of using cte?

1020

What is the purpose of data source?

1043

Can binary strings be converted into numeric or float data types?

1041

Does partitioning improve performance?

981

What are synonyms?

965

How to make a column nullable?

1122

What are the disadvantages of indexes?

1090

Define left outer join?

974

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1607

What are extended events in sql server?

956

What do you mean by a dependent functionality in a build?

1156