Hi Kent,

Thanks for your help, I've managed to get it work using the ROW_NUMBER and partition by clause.