Answer / Sudhir Kumar Trivedi

In SQL Server, 'order by' sorts the result set in ascending or descending order. 'Group by', on the other hand, groups rows that have the same values in specified columns and performs aggregation operations (such as sum, count, etc.) on each group.

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Explain where clause?

1 Answers  

---

Tell me about joins in database system and explain each in detail.

1 Answers   Axtria, ITC Indian Tobacco Company,

---

Can we store videos inside the sql server table?

1 Answers  

---

How to set database to be single_user in ms sql server?

1 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

How to convert a numeric expression from one data type to another?

1 Answers  

---

What are triggers in ms sql server?

1 Answers  

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

What is the difference between dropping a database and taking a database offline?

1 Answers  

---

What is a mutating table error and how can you get around it?

1 Answers  

---

Explain the different index configurations a table can have?

1 Answers  

---