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  

---

What is mapping schema?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

Mention the differences between local and global temporary tables.

0 Answers  

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

What are “lost updates”?

0 Answers  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What is the process of indexing?

0 Answers  

---

Why use cursor in sql server?

0 Answers  

---

According to you what goes into making the best database administrator? : sql server database administration

0 Answers  

---

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---