Answer Posted / vampire007

We use GroupBy clause to analyze data in table,by means of
various sql server aggregate functions like SUM(), AVERAGE
() etc., according to some domain.

For eg., If we want to know the sales done by a every
employee, then we would use somewhat this kind of query:

/**
select employeeid, count(*)
from orders
groupby employeeid
order by employeeid
**/

How to Update from select query in sql server?

992

---

What is stretch database in sql server?

1025

---

How to rebuild the master database?

1008

---

What is dirty read?

1041

---

Explain about builtinadministrator?

983

---

What are the rendering extensions of ssrs?

142

---

What is plan freezing?

907

---

How would we use distinct statement? What is its use?

1022

---

What does REVERT do in SQL Server 2005?

910

---

Why de-normalization required?

938

---

How to name query output columns in ms sql server?

915

---

What is molap and its advantage? : sql server analysis services, ssas

926

---

How and why use sql server?

952

---

What are the 7 disadvantages to a manual system?

906

---

How check triggers in sql server?

913

---