Returns the checksum of the values in a group. Null values are ignored. Can be followed by the Over Clause.
Remarks :
- CHECKSUM_AGG can be used to detect changes in a table.
- The order of the rows in the table does not affect the result of CHECKSUM_AGG. Also, CHECKSUM_AGG functions may be used with the DISTINCT keyword and the GROUP BY clause.
- If one of the values in the expression list changes, the checksum of the list also generally changes. However, there is a small chance that the checksum will not change.
- CHECKSUM_AGG has similar functionality with other aggregate functions.
No comments:
Post a Comment