CHECKSUM_AGG

Returns the checksum of the values in a group. Null values are ignored. Can be followed by the OVER clause.

Syntax

CHECKSUM_AGG ( [ ALL | DISTINCT ] expression )

Arguments

expression

Is an integer expression. Aggregate functions and subqueries are not allowed.

Return types

int

Examples

SELECT CHECKSUM_AGG(DISTINCT [IdNullable]) AS [ValueChecksumAggDist]
  FROM [BasicDataTable]

See Also