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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » OLAP support » Window functions

 

Row numbering functions

Row numbering functions uniquely number the rows in a partition. Two row numbering functions are supported: NUMBER and ROW_NUMBER. It is recommended that you use the ROW_NUMBER function because it is an ANSI standard-compliant function that provides much of the same functionality as the NUMBER(*) function. While both functions perform similar tasks, there are several limitations to the NUMBER function that do not exist for the ROW_NUMBER function.

 See also

ROW_NUMBER function
Mathematical formulas for the aggregate functions