DB2 Relative Row-Number

20150828

select ORGANISATION_CODE
 ,REF_CORRELATION_ID
 ,BATCH_RECEIVED_BATCH_ID
 ,EVENT_RR_LOCAL_REF_ID
 ,EVENT_OPERATION_ID
 
 ,EVENT_RR_DELETE_FLAG
 ,EVENT_RR_TRANS_TS
 
 ,row_number()
  over(partition by ORGANISATION_CODE, EVENT_RR_LOCAL_REF_ID
   order by EVENT_RR_TRANS_TS) as OPSEQ

from NPF.NPF_EVENT_REFERRAL_RECEIVED