with cte
as
(
select id,Doctype,DocName,[Priority], StartDate,[finalDoc],RANK() over (partition by DocName order by [Priority] asc,StartDate desc) as r_no
from #t
) SELECT id,Doctype,DocName,[Priority], StartDate,[finalDoc] from cte...