skip to main content
Supported SQL Statements and Extensions : Create Sequence : Next Value For Clause
  

Try DataDirect Drivers Now

Next Value For Clause

Purpose

Specifies the next value for a sequence that is used in a Select, Insert, or Update statement.

Syntax

NEXT VALUE FOR sequence_name
where:
sequence_name
specifies the name of the sequence from which to retrieve the value.

Example

This example retrieves the next value or set of values in Sequence1:
SELECT NEXT VALUE FOR Sequence1 FROM Account