Reference material for HASH_AGG
*
is specified as an argument - calculates a hash aggregation over all columns in the input. Performing a hash aggregation operation is useful for warming up table data or to check if the same values exist in two different tables.
Alias: CHECKSUM
Parameter | Description | Supported input types |
---|---|---|
<expression> | A column name for specific results for the HASH_AGG function to be applied to | Any <column> name |
BIGINT
tournament_information
:
tournament_information
:
1,889,915,309,908,437,919
The next example calculates a hash aggregation based on columns prizedollars
and tournamentid
only.
3,058,600,455,882,068,351