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

7 Answers  

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

What is the maximum number of index per table?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

What is rtm version in sql server?

0 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

How to turn off warning messages during php execution?

0 Answers  

---

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---