Returns the checksum of the values in a group. Null values are ignored. Can be followed by the OVER clause.
CHECKSUM_AGG ( [ ALL | DISTINCT ] expression )
expression
Is an integer expression. Aggregate functions and subqueries are not allowed.
int
SELECT CHECKSUM_AGG(DISTINCT [IdNullable]) AS [ValueChecksumAggDist] FROM [BasicDataTable]
Functions