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

Why we need a group by clause?

Question Posted / ricky

Answer Posted / ricky

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why I can not enter 0.001 second in date and time literals in ms sql server?

1045

What are system databases into sql server (2005/2008) : sql server database administration

996

What is field with example?

906

What is normalization and what are the advantages of it?

959

What factors you will consider calculating the storage requirement for that view?

933

What are sql servers used for?

1021

What is the difference between varchar and varchar(max) datatypes?

1047

Mention the different types of replication in sql server.

1006

Does index speed up select statements?

1001

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

886

What is a transactions?

1027

What is the command dbcc checkdb used for?

995

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1082

Explain left outer join and right outer join?

1013

How to create a view on an existing table in ms sql server?

1105