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  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

Explain identity in sql server?

0 Answers  

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

What are tasks?

3 Answers   Wipro,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---