Aggregate Functions in SQL SERVER 2008

Question

Hi What are Aggregate functions in SQL SERVER 2008. Explain Aggregate functions in SQL SERVER 2008 with example.

Jignesh Trivedi · Answer

hi Aggregate functions are built in sql server functions that performs a computation on a set of values rather than on a single value or perform a calculation on a set of values and return a single value. please refer http://www.c-sharpcorner.com/uploadfile/suthish_nair/aggregate-functions-in-sql-server-2008/ hope this help.

MuthuMari M · Answer

Hi Aggregate functions perform a calculation on a set of values and return a single value. Except for COUNT aggregate functions ignore null values. Aggregate functions are frequently used with the GROUP BY clause of the SELECT statement. Following functions are aggregate functions. AVG MIN CHECKSUM_AGG SUM COUNT STDEV COUNT_BIG STDEVP GROUPING VAR MAX VARP pls refer this url for more info: http://msdn.microsoft.com/en-us/library/ms173454.aspx thanks. If this post is useful then mark it as  Accepted Answer