The challenge is to identify the sequence of accounting transactions. The table has data which is ordered. You need to follow the order of the data, and detect a certain condition which lasts for a sequence of data rows, you need to give these data poi

The puzzle is solved using recursive CTE.created rownumber in the first CTE and comparing the rows in SECOND cte.

The challenge is to identify the sequence of accounting transactions.

correction

v1b

Sorry the problem was in except. First obtain maximun dates where finished the transactions select ROW_NUMBER() over(partition by accountNo ,instrumentId order by accountNo,instrumentID,tradeDatesOrder ) as id,* from tc76 where TotalQty=0 or tradeDatesO