OLAP functions

Sybase IQ currently supports these OLAP functions:

• Corr()

• Covar_Pop()

• Covar_Samp()

• Cume_Dist

• Dense_Rank()

• Exp_Weighted_Avg

• First_Value

• Last_Value

• Median

• Ntile()

• Percent_Rank()

• Percentile_Cont()

• Percentile_Disc()

• Rank()

• Regr_Avgx()

• Regr_Avgy()

• Regr_Intercept()

• Regr_R2

• Regr_Slope()

• Regr_Sxx()

• Regr_Sxy()

• Regr_Syy()

• StdDev()

• Stddev_Pop

• Stddev_Samp

• Var_Pop

• Var_Samp

• Variance()

• Weighted_Avg

SQL Anywhere supports all of the Sybase IQ OLAP functions.

Currently, Adaptive Server Enterprise does not support OLAP functions.

CIS functional compensation does not support OLAP functions.