Returns the hexadecimal row hash value of one or more expressions.

Syntax

HASHROW ( [ expression [,...]] )

Arguments

expression: any valid expression. If omitted, all columns is assumed.

Returns

The returned value is of type BIGINT, with values as defined below.

Argument List Return Value
Empty The resulting row hash value for all columns.
Expression or list of expressions which all evaluate to NULL, or an expression which evaluates to zero. ‘00000000’XB
Any expression or list of expressions which evaluate to non-NULL, non-zero values. The resulting row hash value for the expression or list of expressions.

Examples

SELECT HASHROW ( );
SELECT HASHROW (insertDate) FROM payroll2016;