NEXTINT

The NEXTINT function is used to return an integer based on the current row index. This can be useful for generating an auto-incrementing value for each row in a dataset.

Syntax

int NEXTINT()

Example

Return an auto increment value

NEXTINT()

In this example, the function is used to generate an auto-incrementing value for each row in the dataset. The function returns a different integer value for each row, starting with 1 for the first row and incrementing by 1 for each subsequent row. This can be useful for creating a unique identifier for each record in the dataset.