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]