Need help to solve update querry for multiple records.

;with mycte as
(select *,row_number() Over(partition by  identifier,identifier_code  order by effective_date DESC) rn  
from test)

,mycte1 as (
select m.unique_ID, m.identifier,m.identifier_code,d.unique_id as srcUnique_ID 
from mycte m cross apply (select   unique_id, identifier,identifier_code  
from mycte d where rn=1 And identifier=m.identifier and identifier_code =m.identifier_code ) d
)

Update mycte1
Set unique_ID=srcUnique_ID

Select * from test