Example

If you have Patient E8, Visit 1, with four subevents, numbers 0-3, and you want to increment each subevent number by one, write a group update that reads:

subevent_number_new = subevent_number+1 where patient = 'E8'

You must arrange the records with subevent number sorted in descending order because only Subevent 3 will not conflict with an existing record when incremented by 1; there is no existing Subevent 4, but there are existing Subevents 1-3.