AVG

COUNT

Large objects (BLOB, CLOB, and so on) not supported. Version 15: JSON not supported.

CUME_DIST

Version 15 and above.

DENSE_RANK

Version 15 and above.

FIRST_VALUE

Includes ignore nulls. Version 15 and above.

LAST_VALUE

Includes ignore nulls. Version 15 and above.

MAX

Decimal not supported (may introduce rounding error). Version 15: JSON not supported.

MIN

Decimal not supported (may introduce rounding error). MIN (date) incorrectly returns NULL if one of the date columns is NULL. Version 15: JSON not supported.

PERCENT_RANK

 

PERCENTILE_CONT

Version 15 and above.

PERCENTILE_DIST

Version 15 and above.

RANK

 

ROW_NUMBER

 

STDDEV_POP

 

STDDEV_SAMP

 

SUM

 

VAR_POP

 

VAR_SAMP

 

VARIANCE_POP

 

VARIANCE_SAMP

 

LAG

Version 16

LEAD

Version 16