this will also works for u change is id in inner join select emp1.ename

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
10329 Views
I also Faced
E-Mail Answers

Answer Posted / samba shiva reddy . m

this will also works for u change is id in inner join

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is raid? : Sql server database administration

1031

What are the different types of locks in the database?

918

query processing

2156

What is delete query?

933

What is best institute to Learn DotNET And SQL in chennai?

2159

What is service broker? : sql server database administration

984

What are click through reports?

142

What is the use of commit?

992

What is SQL Azure Firewall?

136

What is the purpose of the model database?

1009

Can you explain the disadvantages/limitation of the cursor?

974

What are the differences between substr and charindex in sql server.

1100

Which table keeps information about stored procedures?

931

What is the difference in accessing db between sql server vs sql azure?

174

What is the function of inner join?

1060