I have data in this format

I want to add the DesiredColumn that changes its values every time it sees RTI = 070 in ColA

Can someone please help?

CodePudding user response：

You can use a cumulative sum, something like:

select t.*,
       sum(case when colA = 70 then 1 else 0 end) over (partition by date order by rsn)
from t;

I am guessing that you want this per value of date and the ordering is based on rsn. If that is not true, remove the partition by clause.

Sql Fiddle: http://sqlfiddle.com/#!18/59e49/10