Skip to Content
0
Jun 21, 2016 at 07:05 PM

Continue row number sequence from the largest number

76 Views

Hi experts,

I have a scenario where I need to continue the row number sequence from the last maximum number in the column by partition field.

I think that the following screenshot illustrates the example the best:

The red values do not exist in the source table and need to be derived, is there a window function to be used for this

Thanks

Attachments

example.PNG (2.4 kB)