Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

What are the difference between “where” and “having” clause in sql server?

0 Answers  

---

What are tasks?

3 Answers   Wipro,

---

Does hive support indexing?

0 Answers  

---

Explain atomicity?

0 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

What is data compression?

0 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

How to install sql server 2005 express edition?

0 Answers  

---