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,

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

What is database replication?

0 Answers  

---

How do you load large data to the SQL server database?

2 Answers  

---

Why do we use non clustered index?

0 Answers  

---

---

What is table constraint?

0 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

When should you use an instead of trigger?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---