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