forum

Home / DeveloperSection / Forums / SQL SERVER GROUP BY CLAUSE

Ask Question

SQL SERVER GROUP BY CLAUSE

Anonymous User 1258 06-Nov-2015
 i want to use group by clause in sqlserver how to write select query in sql. please help me.
.net sql server 
Updated on 06-Nov-2015
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

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

answer 415870611104049

Liked By