Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » OLAP support » Window functions in SQL Anywhere » Row numbering functions


Mathematical formulas for the aggregate functions

For information purposes, the following two tables provide the equivalent mathematical formulas for all the window aggregate functions supported in SQL Anywhere.

Simple aggregate functions
Formulas for the simple aggregate functions
Statistical aggregate functions
Formulas for the statistical aggregate functions