data.world
Contents
  • Concepts
    • Basic
      • Learn SQL Basics
      • The SELECT and FROM 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
      • Aggregations
      • GROUP BY and FILTER
      • HAVING
      • UNION, INTERSECT, and MINUS
      • POSITION
      • CASE
      • IN and NOT IN
      • CAST
      • Working With Strings
      • Working With Dates
    • Advanced
      • WITH
      • Inline Subqueries
      • Value blocks
      • Special Uses of Inline Subqueries
      • Advanced Aggregate Functions
      • ROLLUP and CUBE
      • PIVOT
      • UNPIVOT
      • TABLESAMPLE
      • Metadata Tables
      • Lexical Issues
    • data.world Specific
      • Multi-Tables
      • Federated Queries
      • Parameterized Queries
      • Special Columns
  • Reference
    • Boolean Aggregations
    • Regression Aggregations
    • Standard Aggregations
    • Statistical Aggregations
    • Other Aggregations
    • All Functions
    • Date Functions
    • General Functions
    • Hash Functions
    • Linked Data Functions
    • Math Functions
    • String Functions
    • URL Extraction Functions
    • Aggregations
      • APPROX_DISTINCT
      • APPROX_PERCENTILE
      • APPROX_MEDIAN
      • AVG
      • ARBITRARY
      • BOOL_AND
      • BOOL_OR
      • COUNT
      • CORRELATION
      • CHECKSUM
      • COUNT_IF
      • GROUP_CONCAT
      • COVAR_POP
      • COVAR_SAMP
      • KURTOSIS
      • MAX_BY
      • REGR_AVGX
      • MIN
      • REGR_AVGY
      • MAX
      • MIN_BY
      • REGR_COUNT
      • REGR_INTERCEPT
      • REGR_SLOPE
      • REGR_R2
      • REGR_SXX
      • REGR_SXY
      • REGR_SYY
      • SKEWNESS
      • STD_SAMP
      • STDEV
      • STD_POP
      • SUM
      • VAR_POP
      • VAR_SAMP
      • VARIANCE
    • Functions
      • ABS
      • ACOS
      • AT_TIME_ZONE
      • ASIN
      • ATAN2
      • ATAN
      • ATTR_OF
      • CEILING
      • COALESCE
      • CONCAT
      • COS
      • COSH
      • DATE_ADD
      • DATE_DIFF
      • DATE_FORMAT
      • DATE_PARSE
      • DATE_PART
      • DATE_SUB
      • DATE_TRUNC
      • DAY
      • DEGREES
      • EXP
      • FLOOR
      • GREATEST
      • EXP10
      • HOURS
      • IRI_OF
      • IF
      • LEAST
      • LABEL_OF
      • LEFT
      • LENGTH
      • LOG
      • LOG10
      • LOWER
      • LTRIM
      • LPAD
      • MD5
      • MID
      • MINUTES
      • MOD
      • MONTH
      • PI
      • POSITION
      • NOW
      • POW
      • RADIANS
      • REGEX
      • REGEXP_EXTRACT
      • REPLACE
      • RIGHT
      • ROUND
      • RPAD
      • RTRIM
      • SECONDS
      • SHA1
      • SHA256
      • SHA384
      • SHA512
      • SIGN
      • SIN
      • SINH
      • SQRT
      • STRING_SPLIT
      • SUBSTRING
      • TAN
      • TANH
      • TRIM
      • UPPER
      • URL_EXTRACT_FRAGMENT
      • URL_EXTRACT_HOST
      • URL_EXTRACT_PARAMETER
      • URL_EXTRACT_PATH
      • URL_EXTRACT_PORT
      • URL_EXTRACT_PROTOCOL
      • URL_EXTRACT_QUERY
      • YEAR
Reference/

All Functions

A list of all functions

  • ABS
  • ACOS
  • ASIN
  • AT_TIME_ZONE
  • ATAN
  • ATAN2
  • ATTR_OF
  • CEILING
  • COALESCE
  • CONCAT
  • COS
  • COSH
  • DATE_ADD
  • DATE_DIFF
  • DATE_FORMAT
  • DATE_PARSE
  • DATE_PART
  • DATE_SUB
  • DATE_TRUNC
  • DAY
  • DEGREES
  • EXP
  • EXP10
  • FLOOR
  • GREATEST
  • HOURS
  • IF
  • IRI_OF
  • LABEL_OF
  • LEAST
  • LEFT
  • LENGTH
  • LOG
  • LOG10
  • LOWER
  • LPAD
  • LTRIM
  • MD5
  • MID
  • MINUTES
  • MOD
  • MONTH
  • NOW
  • PI
  • POW
  • RADIANS
  • REGEX
  • REGEXP_EXTRACT
  • REPLACE
  • RIGHT
  • ROUND
  • RPAD
  • RTRIM
  • SECONDS
  • SHA1
  • SHA256
  • SHA384
  • SHA512
  • SIGN
  • SIN
  • SINH
  • SQRT
  • STRING_SPLIT
  • SUBSTRING
  • TAN
  • TANH
  • TRIM
  • UPPER
  • URL_EXTRACT_FRAGMENT
  • URL_EXTRACT_HOST
  • URL_EXTRACT_PARAMETER
  • URL_EXTRACT_PATH
  • URL_EXTRACT_PORT
  • URL_EXTRACT_PROTOCOL
  • URL_EXTRACT_QUERY
  • YEAR