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#