CHECKSUM

Creates an order-independent checksum of a set of values. This function can be used to compare two sets of values for equivalence, or to validate that a set of values has not changed as it's dataset evolves.

Parameter Type Description
value
any
The values to form a checksum of.
Returns: string

Example

query:

SELECT  CHECKSUM(close_value) AS checksum,sales_agent
  FROM sales_pipeline
 WHERE deal_stage = "Won"
 group by sales_agent

result:

sales_agent checksum
957e81c9da4cbb03 Maureen Marcano
59cc2347c6c9c7a7 Boris Faz
24602ba72fe0e666 Jonathan Berthelot
9a5eb6c97c40155c Vicki Laflamme
a2a1ee4d11555604 Donn Cantrell
3560e1d86450c488 Wilburn Farren
e4f556a493639d51 Cassey Cress
8107f4f941073e73 Elease Gluck