Friday, February 15, 2013

Aggregate Functions in SQL-Server 2012

Aggregate Functions in SQL-Server 2012

Aggregate functions perform calculations on a set of values and return single value. 
All aggregate functions work with non-null values except count.
Aggregate functions frequently used with the Group By Clause of the Select statement.

   Used in    1) Select clause  2) Having clause.
 
AVG CHECKSUM_AGG COUNT COUNT_BIG GROUPING
GROUPING_ID MAX MIN SUM STDEV
STDEVP VAR VARP




tags: Aggregate Functions in Sql-Server 2012, Functions used in Group data in sql-server

No comments:

Post a Comment