with a as
(
 select *, row_number() over (partition by Account order by [столбец(ы) упорядочивания]) as rn from [Таблица]
)
select
 Tag, Account
from
 a
where
 rn = 1;