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

siyeh/sql-crm-example-data Run query Copy code

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