forum

home / developersection / forums / sql server group by clause

Ask Question

SQL SERVER GROUP BY CLAUSE

Anonymous User 1455 06-Nov-2015

i want to use group by clause in sqlserver how to write select query in sql. please help me.

sql server

Updated on 06-Nov-2015

Anonymous User

Other

I am a content writter !

Message

Can you answer this question?

Answer

1 Answers

Anonymous User

06-Nov-2015

The SQL Server (Transact-SQL) GROUP BY clause is used in a SELECT statement to collect data across multiple records and group the results by one or more columns.The syntax for the GROUP BY clause in SQL Server (Transact-SQL) is:

SELECT expression1, expression2, ... expression_n,
aggregate_function (expression) FROM tables WHERE conditions GROUP BY
expression1, expression2, ... expression_n;

Example:

select count(CustomerID) as totrecord,CustomerID,CustomerName,Address,City,PostalCode,Country from

Customer

group by CustomerID,CustomerName,Address,City,PostalCode,Country

forum

SQL SERVER GROUP BY CLAUSE

Anonymous User

Can you answer this question?

1 Answers

Liked By