Generates integer values, starting at 1, for each successive row in a query. Its implementation is identical to that of the NUMBER function.
SyntaxIDENTITY( expression )
Parametersexpression An expression. The expression is parsed, but is ignored during the execution of the function.
ReturnsINT
RemarksFor a description of how to use the IDENTITY function, see NUMBER function [Miscellaneous].
See also Standards and compatibilitySQL/2008 Vendor extension.
ExampleThe following statement returns a sequentially-numbered list of employees.
SELECT IDENTITY( 10 ), Surname FROM Employees; |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |