Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Aggregate FunctionsRSS Feeds

Aggregate Functions

Posted By: Sarita Patel     Category: SQL Server     Views: 6186

This article explains about aggregate functions available in sql server with different examples.

Aggregate functions is used to perform a calculation on a set of values and return a single value. All aggregate functions are deterministicmeans always return the same result any time they are called with a specific set of input values.

 

Aggregate functions can be used as an expressions only in select list of a SELECT statement, in COMPUTE or COMPUTE BY clause or in HAVING clause.

 

Below are the aggregate functions available in sql server.

 

MAX

MIN

SUM

STDEV

STDEVP

VAR

VARP

AVG

BINARY_CHECKSUM

CHECKSUM

CHECKSUM_AGG

COUNT

COUNT_BIG

GROUPING

 

  
Share: 


Didn't find what you were looking for? Find more on Aggregate Functions Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of Aggregate Functions is from United States.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!