Why we need a group by clause?

Question Posted / honeysukumar

4 Answers
10621 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Why we need a group by clause?..

Answer / sd

While using aggregate functions.

Is This Answer Correct ?

7 Yes

1 No

Why we need a group by clause?..

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

Is This Answer Correct ?

7 Yes

1 No

Why we need a group by clause?..

Answer / satyanarayana

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

Is This Answer Correct ?

1 Yes

0 No

Why we need a group by clause?..

Answer / ricky

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer