SeqNum Numeric
Summary
The SeqNum function returns an increasing number beginning from an optional start number.
Syntax
SeqNum([start]) |
Return Type
Details
The function restarts the count for each query submitted. The default start number is 1.
Examples
select SeqNum(), name from delta.foo;select SeqNum(100), name from delta.foo; insert into delta.some_table (col1) values (SeqNum()); |