select row_number() over (PARTITION BY department_id order by record_date desc) rn ,count,exceptioncount,percent,recode_date
select row_number() over (PARTITION BY department_id order by record_date desc) rn ,count,exceptioncount,percent,recode_date