hash

Compute hashcode of a string.

Get the hashcode value (double) of a column (string type).

Usage Details

select *, hash(column) as hashCode from tableName

-- column: column name to compute hash code
-- tableName: name of a table

-- returnValue: hash code value (double) of a column

Example

Input
table

id user
1emil
2logichub
select *, hash(user) as hashCode from table

Output

id user
1emil3117003.0
2logichub2.022441175E9

© 2017-2021 LogicHub®. All Rights Reserved.