SQL capabilities for minimum aggregation and comparison controls

CACHE TABLE

Query hints

Analysis template (parameterized queries)

SELECT

SELECT DISTINCT

FROM

FROM SUBQUERY

FROM INLINE TABLE (VALUES)

WHERE

GROUP BY

HAVING

ORDER BY

WITH (CTE)

GROUP BY CUBE

GROUP BY ROLLUP

GROUP BY GROUPING SETS

EXISTS

CLUSTER BY

DISTRIBUTE BY

SORT BY

LATERAL JOIN

PIVOT / UNPIVOT

WITH RECURSIVE

JOIN INNER

JOIN LEFT

JOIN FULL OUTER

JOIN CROSS

JOIN RIGHT

JOIN NATURAL

JOIN LEFT SEMI

JOIN LEFT ANTI

UNION

UNION ALL

EXCEPT

EXCEPT ALL

INTERSECT

INTERSECT ALL

ORDER BY ASC / DESC

ORDER BY NULLS FIRST

ORDER BY NULLS LAST

LIMIT

OFFSET

=

!= / <>

<

<=

>

>=

IN

NOT IN

LIKE

NOT LIKE

RLIKE

BETWEEN

IS TRUE / IS FALSE

AND

OR

NOT

IS DISTINCT FROM

<=> (null-safe equality)

AVG function

COUNT function

COUNT DISTINCT function

SUM function

MIN function

MAX function

STDDEV / STDDEV_SAMP functions

STDDEV_POP function

VAR_SAMP / VARIANCE functions

VAR_POP function

SKEWNESS function

APPROX_COUNT_DISTINCT function

COLLECT_LIST function

COLLECT_SET function

PERCENTILE function

APPROX_PERCENTILE function

MEDIAN function

ANY_VALUE function

BOOL_AND function

BOOL_OR function

ARRAY function

ARRAY_CONTAINS function

ARRAY_DISTINCT function

ARRAY_INTERSECT function

ARRAY_JOIN function

ARRAY_REMOVE function

ARRAY_SORT function

ARRAY_UNION function

FLATTEN function

EXPLODE function

ARRAY_EXCEPT function

IS NULL function

IS NOT NULL function

GREATEST function

LEAST function

CASE / WHEN functions

IF function

COALESCE function

NULLIF function

NVL function

NVL2 function

STRUCT function

NAMED_STRUCT function

MAP function

STR_TO_MAP function

BASE64 function

UNBASE64 function

HEX function

UNHEX function

TO_DATE function

DECODE function

ENCODE function

CAST function

TO_CHAR function

TO_NUMBER function

CURRENT_DATE function

CURRENT_TIMESTAMP function

TO_TIMESTAMP function

DATE_DIFF function

DATE_TRUNC function

DATE_PART function

EXTRACT function

CONVERT_TIMEZONE function

FROM_UTC_TIMESTAMP function

TIMESTAMP function

DAY / DAYOFMONTH functions

DAYOFWEEK function

WEEKOFYEAR function

MONTH function

YEAR function

HOUR function

MINUTE function

SECOND function

DAYOFYEAR function

DATE_ADD function

ADD_MONTHS function

MD5 function

SHA function

SHA1 function

SHA2 function

XXHASH64 function

GET_JSON_OBJECT function

TO_JSON function

ABS function

CEIL / CEILING functions

FLOOR function

ROUND function

LN function

LOG / LOG10 functions

POWER function

SQRT function

RAND / RANDOM functions

EXP function

SIGN function

TRUNC function

TRUNCATE function

CBRT function

PI function

RADIANS function

ACOS function

ASIN function

ATAN function

ATAN2 function

COS function

COT function

SIN function

DEGREES function

+

-

*

/

%

CARDINALITY function

SIZE function

CONCAT function

LOWER function

UPPER function

LENGTH / CHAR_LENGTH / CHARACTER_LENGTH functions

SUBSTR / SUBSTRING functions

TRIM function

BTRIM function

LTRIM function

RTRIM function

POSITION function

REPLACE function

REPEAT function

REGEXP_REPLACE function

REGEXP_SUBSTR function

SPLIT function

FORMAT_STRING function

UUID function

LPAD function

RPAD function

LEFT function

RIGHT function

REVERSE function

TRANSLATE function

REGEXP_COUNT function

REGEXP_INSTR function

SPLIT_PART function

consent_tcf_v2_decode function

consent_gpp_v1_decode function

ROW_NUMBER function

RANK function

DENSE_RANK function

LAG function

LEAD function

Window AVG function

Window COUNT function

Window SUM function

Window MIN function

Window MAX function

Window STDDEV_POP function

Window STDDEV_SAMP function

Window VAR_POP function

Window VAR_SAMP function

Window SKEWNESS function

Window APPROX_COUNT_DISTINCT function

Window APPROX_PERCENTILE function

Window PERCENTILE function

FIRST / FIRST_VALUE functions

LAST / LAST_VALUE functions

NTH_VALUE function

CUME_DIST function

PERCENT_RANK function

NTILE function

AES_ENCRYPT function

AES_DECRYPT function

HLL_SKETCH_AGG function

HLL_UNION_AGG function

HLL_SKETCH_ESTIMATE function

HLL_UNION function