Row numbering functions uniquely number the rows in a partition. SQL Anywhere supports two row numbering functions; 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 SQL Anywhere 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.
ROW_NUMBER function
Mathematical formulas for the aggregate functions
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |