Contents Index HTTP_VARIABLE function [HTTP] IFNULL function [Miscellaneous]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

IDENTITY function [Miscellaneous]


Function 

Generates integer values, starting at 1, for each successive row in a query. Its implementation is identical to that of the NUMBER function.

Syntax 

IDENTITY ( expression )

Parameters 

expression    An expression. The expression is parsed, but is ignored during the execution of the function.

Usage 

For a description of how to use the IDENTITY function, see the NUMBER function [Miscellaneous].

Standards and compatibility 
See also 

NUMBER function [Miscellaneous]

Example 

The following statement returns a sequentially-numbered list of employees.

SELECT IDENTITY( 10 ), emp_lname FROM employee

Contents Index HTTP_VARIABLE function [HTTP] IFNULL function [Miscellaneous]