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
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
Array Functions
Formatting Functions
All Functions
Color Functions
Date Functions
Hash Functions
General Functions
Linked Data Functions
Security Functions
Math Functions
URL Extraction Functions
String Functions
Aggregations
APPROX_MEDIAN
APPROX_PERCENTILE
APPROX_DISTINCT
ARBITRARY
ARRAY_AGG
AVG
BOOL_OR
COUNT
BOOL_AND
CHECKSUM
CORRELATION
COUNT_IF
COVAR_POP
COVAR_SAMP
FIRST_VALUE
GROUP_CONCAT
DENSE_RANK
CUME_DIST
GROUPING
KURTOSIS
LEAD
LAST_VALUE
LAG
MAX
MAX_BY
MIN
NTH_VALUE
MIN_BY
NTILE
PERCENT_RANK
REGR_AVGY
REGR_AVGX
REGR_COUNT
RANK
REGR_INTERCEPT
REGR_SLOPE
REGR_SXX
REGR_R2
REGR_SXY
REGR_SYY
STD_SAMP
STD_POP
ROW_NUMBER
SUM
SKEWNESS
VAR_POP
VARIANCE
STDEV
VAR_SAMP
Functions
ABS
ARRAY
ARRAY_APPEND
ACOS
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_JOIN
ARRAY_LENGTH
ASIN
ARRAY_PREPEND
ATAN
AT_TIME_ZONE
ATAN2
ATTR_OF
COALESCE
BOLD
CHAR
CEILING
COLOR
COS
CONCAT
COSH
CURRENT_USER
DATE_ADD
CURRENT_USER_IN_GROUP
DATE_FORMAT
DATE_DIFF
DATE_PARSE
DATE_PART
DATE_SUB
DATE_TRUNC
DAY
ELEMENT_AT
DEGREES
EXP
EXP10
GREATEST
HOURS
IF
FLOOR
IRI_OF
ITALIC
JARO_WINKLER_DISTANCE
LEAST
LENGTH
LOG10
LEFT
LPAD
LEVENSHTEIN_DISTANCE
LABEL_OF
LOG
LTRIM
LOWER
MID
MOD
MD5
MONTH
MINUTES
NOW
POSITION
RANDOM
PI
RAND
POW
RADIANS
REGEX
REGEXP_EXTRACT
REPLACE
RGB
RIGHT
ROUND
RPAD
RTRIM
SECONDS
SHA384
SHA1
SHA512
SHA256
SIGN
SIN
SINH
SOUNDEX
SOUNDEX_DISTANCE
STRING_SPLIT
STATUS
SQRT
SUBSTRING
TANH
TRIM
TAN
UPPER
URL_EXTRACT_FRAGMENT
URL_EXTRACT_HOST
URL_EXTRACT_PARAMETER
URL_EXTRACT_PORT
URL_EXTRACT_PATH
URL_EXTRACT_PROTOCOL
URL_EXTRACT_QUERY
WITH_COLOR
WITH_BACKGROUND_COLOR
WITH_STATUS
YEAR
WITH_LINK
Reference
/
Color Functions
A list of color functions
COLOR
RGB
STATUS