For only certain records I need to query the most recent image01 field (i.e. MAX(DATE)) record. I'm close but not quite there. Your help is greatly appreciated. Thank you.
select employee_id, image01,
row_number() over(partition by employee_id order by date desc) as rn
where employee_id in (