How to add additional conditions in SQL?

0 Answers   Amdocs,

---

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 do I find the query plan in sql server?

0 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

What is the advantage of sql server?

0 Answers  

---

What functions can a view be used to performed?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---