I need to update a sequence number column based upon another column. In the example below column 1 will have multiple instances of the same value (in this case 100 and 101). I need the first value (based on timestamp) to be given the value ‘0’ and subsequent rows ‘previous value +1’. My issue is that this a rather large table with many different values in column 1 so updating the table manually is not really an option. What I was hoping to do is have a query that walks through the table and apply the appropriate sequence numbers automatically.
Thanks in advance for any help!