Answer / sd

While using aggregate functions.

Answer / 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
**/

Answer / satyanarayana

In order to provide a condition to the select statement
either by group by column or aggregate function

Answer / ricky

while we are using a aggregate function we use the group by
clause....

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

How do I find the port number for sql server?

0 Answers  

---

What is entity data services?

0 Answers  

---

What is view in sql?

0 Answers  

---

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

How to test subquery results with the exists operator?

0 Answers  

---

Can we use where clause with group by?

0 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

How to optimize stored procedures in sql server?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---