Built-in functions¶
This article provides an alphabetical list of built-in functions shared by the different dialects.
ANSI SQL |
Snowflake |
|---|---|
ABS |
|
ACOS |
|
ACOSH |
|
ANY_VALUE |
|
APPROX_COUNT_DISTINCT |
|
ARRAY |
|
ASCII |
|
ASIN |
|
ASINH |
|
ATAN |
|
ATAN2 |
|
ATANH |
|
ATN2 |
|
AVE |
|
AVERAGE |
|
AVG |
|
BTRIM |
|
CBRT |
|
CEIL |
|
CEILING |
|
CHARACTER_LENGTH |
|
CHARINDEX |
|
CHAR_LENGTH |
|
CHR |
|
COALESCE |
|
CONCAT |
|
CORR |
|
COS |
|
COSH |
|
COT |
|
COUNT |
|
COVAR_POP |
|
COVAR_SAMP |
|
CUME_DIST |
|
CURDATE |
|
CURRENT_DATABASE |
|
CURRENT_DATE |
|
CURRENT_SCHEMA |
|
CURRENT_TIMESTAMP |
|
CURRENT_USER |
|
DATE |
|
DECODE |
|
DEGREES |
|
DENSE_RANK |
|
EXP |
|
FIRST_VALUE |
|
FLOOR |
|
GREATEST |
|
GROUPING |
|
IF |
|
IFF |
|
IFNULL |
|
IIF |
|
INITCAP |
|
KURTOSIS |
|
LAG |
|
LAST_DAY |
|
LAST_VALUE |
|
LEAD |
|
LEAST |
|
LEFT |
|
LEN |
|
LENGTH |
|
LN |
|
LOG |
|
LOWER |
|
LPAD |
|
LTRIM |
|
MAX |
|
MAXIMUM |
|
MEDIAN |
|
MIN |
|
MINIMUM |
|
MOD |
|
NOW |
|
NTH_VALUE |
|
NTILE |
|
NULLIF |
|
NULLIFZERO |
|
NVL |
|
NVL2 |
|
OCTET_LENGTH |
|
PERCENTILE_CONT |
|
PERCENTILE_DISC |
|
PERCENT_RANK |
|
PI |
|
POSITION |
|
POW |
|
POWER |
|
RADIANS |
|
RANDOM |
|
RANK |
|
REGEXP_COUNT |
|
REGEXP_SUBSTR |
|
REGR_AVGX |
|
REGR_AVGY |
|
REGR_COUNT |
|
REGR_INTERCEPT |
|
REGR_SLOPE |
|
REGR_SXX |
|
REGR_SXY |
|
REGR_SYY |
|
REPEAT |
|
REPLACE |
|
REPLICATE |
|
RIGHT |
|
ROLLUP |
|
ROUND |
|
ROW_NUMBER |
|
RPAD |
|
RTRIM |
|
SHA1 |
|
SHA2 |
|
SIGN |
|
SIN |
|
SOUNDEX |
|
SPACE |
|
SPLIT_PART |
|
SQRT |
|
STDDEV_POP |
|
STDDEV_SAMP |
|
STDDEV |
|
SUBSTR |
|
SUBSTRING |
|
SUM |
|
TAN |
|
TANH |
|
TIMESTAMP |
|
TO_TIMESTAMP |
|
TRANSLATE |
|
TRIM |
|
UCASE |
|
UPPER |
|
USER |
|
VAR_POP |
|
VAR_SAMP |
|
VARIANCE_POP |
|
VARIANCE_SAMP |
|
VARIANCE |
|
VARP |
|
WIDTH_BUCKET |
|
ZEROIFNULL |