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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » OLAP Support » Window functions

PERCENT_RANK function Next Page

Row numbering functions


While there are two row numbering functions supported by SQL Anywhere, NUMBER and ROW_NUMBER, it is recommended that you use the ROW_NUMBER function whenever possible. While both functions perform similar tasks, there are several limitations to the NUMBER function that do not exist for the ROW_NUMBER function. See NUMBER function [Miscellaneous].


ROW_NUMBER function