Aggregate Functions in SQL Server

Aggregate functions perform the calculation on the data and will return a single value as the out put.

In real time aggregate functions are used to calculate the minimum, maxmimum and average statistics.

HAVING Clause is mostly used to operate along with the aggregate functions.

Most frequently used Aggregate functions are:
Less frequently used aggregate functions are:
  • CHECKSUM
  • COUNT_BIG
  • CHECKSUM_AGG
  • BINARY_CHECKSUM
  • GROUPING
  • VAR
  • VARP
  • STDEV
  • STDEVP

This entry was posted in , . Bookmark the permalink.

Leave a reply