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