- Concepts
- Basic
- Intermediate
- Advanced
- data.world Specific
- Reference
- Boolean Aggregations
- Regression Aggregations
- Standard Aggregations
- Statistical Aggregations
- Other Aggregations
- PRAGMA Statements
- Array Functions
- All Functions
- Color Functions
- Date Functions
- Formatting Functions
- General Functions
- Hashing and Related Functions
- Security Functions
- String Functions
- Linked Data Functions
- Math Functions
- URL Extraction Functions
- Aggregations
- APPROX_DISTINCT
- APPROX_PERCENTILE
- APPROX_MEDIAN
- ARRAY_AGG
- ARBITRARY
- AVG
- BOOL_AND
- CHECKSUM
- CORRELATION
- BOOL_OR
- COUNT
- COUNT_IF
- COVAR_POP
- CUME_DIST
- COVAR_SAMP
- DENSE_RANK
- FIRST_VALUE
- GROUP_CONCAT
- KURTOSIS
- GROUPING
- LAG
- LEAD
- LAST_VALUE
- MAX_BY
- MAX
- MIN
- NTH_VALUE
- NTILE
- PERCENT_RANK
- RANK
- MIN_BY
- REGR_AVGX
- REGR_AVGY
- REGR_COUNT
- REGR_INTERCEPT
- REGR_R2
- REGR_SLOPE
- REGR_SXY
- REGR_SXX
- REGR_SYY
- ROW_NUMBER
- SKEWNESS
- STD_SAMP
- STD_POP
- SUM
- STDEV
- VAR_POP
- VAR_SAMP
- VARIANCE
- Functions
- ABS
- ACOS
- ARRAY_APPEND
- ARRAY
- ARRAY_CONCAT
- ARRAY_CONTAINS
- ARRAY_JOIN
- ARRAY_LENGTH
- ARRAY_LOWER
- ARRAY_PREPEND
- ASIN
- ATAN
- AT_TIME_ZONE
- ATAN2
- ATTR_OF
- BASE64_TO_HEX
- BOLD
- CEILING
- COLOR
- COALESCE
- CHAR
- COS
- COSH
- CONCAT
- CURRENT_USER
- CURRENT_USER_IN_GROUP
- DATE_ADD
- DATE_COMPARE
- DATE_DIFF
- DATE_FORMAT
- ARRAY_UPPER
- DATE_PARSE
- DATE_PART
- DAY
- DATE_SUB
- DATE_TRUNC
- DEGREES
- ELEMENT_AT
- ENDSWITH
- EXP
- EXP10
- FLOOR
- GENERATE_SERIES
- GREATEST
- HEX_TO_BASE64
- HOURS
- IF
- IRI_OF
- IRI_TO_RESOURCE_HASH
- ITALIC
- JARO_WINKLER_DISTANCE
- LABEL_OF
- LEAST
- LENGTH
- LEFT
- LEVENSHTEIN_DISTANCE
- LOG
- LOG10
- LOWER
- LPAD
- LTRIM
- MD5
- MID
- MINUTES
- MOD
- MONTH
- NOW
- NOW_UTC
- PI
- POSITION
- POW
- RADIANS
- RAND
- RANDOM
- REGEX
- REPLACE
- REGEXP_EXTRACT
- RGB
- RIGHT
- REVERSE
- ROUND
- SECONDS
- RPAD
- SHA256
- RTRIM
- SHA384
- SHA512
- SHA1
- SIGN
- SINH
- SIN
- SOUNDEX
- SOUNDEX_DISTANCE
- SQRT
- STARTSWITH
- STATUS
- STR_AFTER
- STR_BEFORE
- STR_CONTAINS
- STRING_SPLIT
- SUBSTRING
- TAN
- TANH
- TRIM
- UPPER
- TRUNC
- URL_EXTRACT_FRAGMENT
- URL_EXTRACT_HOST
- URL_EXTRACT_PARAMETER
- URL_EXTRACT_PATH
- URL_EXTRACT_PROTOCOL
- URL_EXTRACT_PORT
- URL_EXTRACT_QUERY
- WITH_COLOR
- WITH_BACKGROUND_COLOR
- WITH_LINK
- WITH_STATUS
- YEAR
Reference/Functions/
A function used to calculate the SHA-256 hash of a data value. The hash will be returned as a hex-encoded string.
Parameter | Type |
---|---|
value_to_hash | any |
Returns: string
Example
query:
SELECT name, SHA256(name) FROM employees ORDER BY name LIMIT 1
siyeh/sql-crm-example-data Run query Copy code
results:
name | sha256 |
---|---|
Anna Snelling | d4c1bce57c3d797dd63389bb3167ff75e5bbbe2ff5a67c1e3efb55207111d6ad |