Generates integer values, starting at 1, for each successive row in a query. Its implementation is identical to that of the NUMBER function.
IDENTITY( expression )
expression An expression. The expression is parsed, but is ignored during the execution of the function.
INT
The description of the IDENTITY function is the same as the description of the NUMBER function.
SQL/2008 Vendor extension.
The following statement returns a sequentially-numbered list of employees.
SELECT IDENTITY( 10 ), Surname FROM Employees; |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |