I need help in writing a query in Oracle for the following data. The data is sorted by Person and Day fields.
Person Day Flag
------ --- ----
person1 day1 1
person1 day2 2
person1 day3 1
person1 day4 2
person1 day5 1
person1 day6 2
person1 day7 3
person1 day8 1
I need to have a Group_Number column that gets incremented whenever the Flag value start from '1'. My result should look as below
Person Day Flag Group_Number
------ --- ---- ------------
person1 day1 1 1
person1 day2 2 1
person1 day3 1 2
person1 day4 2 2
person1 day5 1 3
person1 day6 2 3
person1 day7 3 3
person1 day8 1 4