data.world
Contents
  • Concepts
    • Basic
      • Learn SQL Basics
      • The SELECT and FROM Clauses
      • The SELECT * EXCLUDE and SELECT * RENAME Clauses
      • LIMIT
      • WHERE and Comparison Operators
      • ORDER BY
      • AND, OR, and NOT
      • Arithmetic Operations
      • IS NULL and IS NOT NULL
      • LIKE and NOT LIKE
      • BETWEEN
      • OFFSET
    • Intermediate
      • Working With Joins, Aggregations, and Built-In Functions
      • Joins
      • CAST
      • Aggregations
      • GROUP BY and FILTER
      • HAVING
      • UNION, INTERSECT, and MINUS
      • POSITION
      • CASE
      • IN and NOT IN
      • Working With Strings
      • Working With Dates
      • Working With Arrays
    • Advanced
      • WITH
      • Inline Subqueries
      • Value blocks
      • Special Uses of Inline Subqueries
      • Advanced Aggregate Functions
      • Windowed Aggregations
      • ROLLUP and CUBE
      • PIVOT
      • UNPIVOT
      • TABLESAMPLE
      • Metadata Tables
      • Lexical Issues
    • data.world Specific
      • Multi-Tables
      • Federated Queries
      • Parameterized Queries
      • Special Columns
      • Query past instances of data
      • Text formatting for query outputs
  • Reference
    • Boolean Aggregations
    • Regression Aggregations
    • Standard Aggregations
    • Statistical Aggregations
    • Other Aggregations
    • PRAGMA Statements
    • All Functions
    • Color Functions
    • Array Functions
    • Date Functions
    • Formatting Functions
    • General Functions
    • Linked Data Functions
    • Hashing and Related Functions
    • Math Functions
    • Security Functions
    • String Functions
    • URL Extraction Functions
    • Aggregations
      • APPROX_MEDIAN
      • APPROX_DISTINCT
      • ARBITRARY
      • APPROX_PERCENTILE
      • ARRAY_AGG
      • AVG
      • BOOL_AND
      • BOOL_OR
      • CHECKSUM
      • COUNT
      • CORRELATION
      • COUNT_IF
      • COVAR_POP
      • COVAR_SAMP
      • CUME_DIST
      • DENSE_RANK
      • FIRST_VALUE
      • GROUP_CONCAT
      • LAG
      • KURTOSIS
      • GROUPING
      • LEAD
      • LAST_VALUE
      • MAX
      • MIN
      • MIN_BY
      • MAX_BY
      • NTH_VALUE
      • PERCENT_RANK
      • NTILE
      • RANK
      • REGR_AVGY
      • REGR_COUNT
      • REGR_AVGX
      • REGR_R2
      • REGR_INTERCEPT
      • REGR_SXX
      • REGR_SLOPE
      • REGR_SXY
      • REGR_SYY
      • ROW_NUMBER
      • STD_SAMP
      • SKEWNESS
      • STD_POP
      • STDEV
      • SUM
      • VAR_SAMP
      • VAR_POP
      • VARIANCE
    • Functions
      • ABS
      • ARRAY
      • ACOS
      • ARRAY_CONCAT
      • ARRAY_CONTAINS
      • ARRAY_LOWER
      • ARRAY_JOIN
      • ARRAY_APPEND
      • ARRAY_LENGTH
      • ARRAY_PREPEND
      • ARRAY_UPPER
      • ATAN
      • ASIN
      • AT_TIME_ZONE
      • ATAN2
      • ATTR_OF
      • BASE64_TO_HEX
      • BOLD
      • CHAR
      • CONCAT
      • CEILING
      • COLOR
      • COALESCE
      • COS
      • CURRENT_USER
      • COSH
      • CURRENT_USER_IN_GROUP
      • DATE_ADD
      • DATE_COMPARE
      • DATE_FORMAT
      • DATE_DIFF
      • DATE_PART
      • DAY
      • DATE_PARSE
      • DATE_SUB
      • DATE_TRUNC
      • DEGREES
      • ELEMENT_AT
      • ENDSWITH
      • EXP
      • EXP10
      • FLOOR
      • GENERATE_SERIES
      • GREATEST
      • IF
      • HEX_TO_BASE64
      • IRI_OF
      • IRI_TO_RESOURCE_HASH
      • ITALIC
      • HOURS
      • JARO_WINKLER_DISTANCE
      • LEAST
      • LABEL_OF
      • LEFT
      • LENGTH
      • LEVENSHTEIN_DISTANCE
      • LOG
      • LOG10
      • LOWER
      • LPAD
      • LTRIM
      • MD5
      • MID
      • MINUTES
      • MOD
      • NOW
      • MONTH
      • NOW_UTC
      • POSITION
      • PI
      • POW
      • RADIANS
      • RAND
      • RANDOM
      • REGEXP_EXTRACT
      • REGEX
      • REPLACE
      • REVERSE
      • RIGHT
      • RGB
      • ROUND
      • RTRIM
      • RPAD
      • SECONDS
      • SHA1
      • SHA256
      • SHA384
      • SHA512
      • SIGN
      • SIN
      • SINH
      • SOUNDEX
      • SOUNDEX_DISTANCE
      • SQRT
      • STARTSWITH
      • STATUS
      • STR_AFTER
      • STR_BEFORE
      • STR_CONTAINS
      • TAN
      • STRING_SPLIT
      • SUBSTRING
      • TANH
      • TRIM
      • TRUNC
      • UPPER
      • URL_EXTRACT_FRAGMENT
      • URL_EXTRACT_HOST
      • URL_EXTRACT_PARAMETER
      • URL_EXTRACT_PATH
      • URL_EXTRACT_PORT
      • URL_EXTRACT_PROTOCOL
      • URL_EXTRACT_QUERY
      • WITH_BACKGROUND_COLOR
      • WITH_COLOR
      • WITH_LINK
      • WITH_STATUS
      • YEAR
Reference/

All Functions

A list of all functions

  • ABS
  • ACOS
  • ARRAY_APPEND
  • ARRAY_CONCAT
  • ARRAY_CONTAINS
  • ARRAY_JOIN
  • ARRAY_LENGTH
  • ARRAY_LOWER
  • ARRAY_PREPEND
  • ARRAY_UPPER
  • ARRAY
  • ASIN
  • AT_TIME_ZONE
  • ATAN
  • ATAN2
  • ATTR_OF
  • BASE64_TO_HEX
  • BOLD
  • CEILING
  • CHAR
  • COALESCE
  • COLOR
  • CONCAT
  • COS
  • COSH
  • CURRENT_USER_IN_GROUP
  • CURRENT_USER
  • DATE_ADD
  • DATE_COMPARE
  • DATE_DIFF
  • DATE_FORMAT
  • DATE_PARSE
  • DATE_PART
  • DATE_SUB
  • DATE_TRUNC
  • DAY
  • DEGREES
  • ELEMENT
  • ENDSWITH
  • EXP
  • EXP10
  • FLOOR
  • GREATEST
  • GENERATE_SERI#S
  • HOURS
  • HEX_TO_BASE64
  • IF
  • IRI_OF
  • IRI_TO_RESOURCE_HASH
  • ITALIC
  • JARO_WINKLER_DISTANCE
  • LABEL_OF
  • LEAST
  • LEFT
  • LENGTH
  • LEVENSHTEIN_DISTANCE
  • LOG
  • LOG10
  • LOWER
  • LPAD
  • LTRIM
  • MD5
  • MID
  • MINUTES
  • MOD
  • MONTH
  • NOW
  • NOW_UTC
  • PI
  • POSITION
  • POW
  • RADIANS
  • RAND
  • RANDOM
  • REGEX
  • REGEXP_EXTRACT
  • REPLACE
  • REVERSE
  • RGB
  • RIGHT
  • ROUND
  • RPAD
  • RTRIM
  • SECONDS
  • SHA1
  • SHA256
  • SHA384
  • SHA512
  • SIGN
  • SIN
  • SINH
  • SOUNDEX_DISTANCE
  • SOUNDEX
  • SQRT
  • STATUS
  • STARTSWITH
  • STR_AFTER
  • STR_BEFORE
  • STR_CONTAINS
  • STRING_SPLIT
  • SUBSTRING
  • TAN
  • TANH
  • TRIM
  • TRUNC
  • UPPER
  • URL_EXTRACT_FRAGMENT
  • URL_EXTRACT_HOST
  • URL_EXTRACT_PARAMETER
  • URL_EXTRACT_PATH
  • URL_EXTRACT_PORT
  • URL_EXTRACT_PROTOCOL
  • URL_EXTRACT_QUERY
  • WITH_BACKGROUND_COLOR
  • WITH_COLOR
  • WITH_LINK
  • WITH_STATUS
  • YEAR