Function that will increment a number by 1 each time

[shricky]

i need it to perform like a "sequence" in Oracle at least conceptually. I am wanting some function that increments each row by 1 (almost acting like a primary key for that row).

 

[Goose74]

Running_count(1) should do the trick.

 

[blom0344]

Running-total(1) will work, but only when the data is fetched in the right order. Otherwise the server will generate sequences in a different order than expected. Make sure you sort properly by applying sorts in the query..

Ties Blom