Select all data group by 1 column and functioned by another
;with cte as
(
    select
        ID,
        Priority,
        Type,
        Name,
        row_num = 
            row_number() over (partition by Type order by Priority desc)
    from dbo.your_table
)
select ID, Priority, Type, Name
from cte
where row_num = 1;