drop table if exists test;
create table test (
  k1 UInt64, v1 UInt64, p1 UInt64, ver UInt32
)
ENGINE=ReplacingMergeTree(ver)
PARTITION BY (p1)
ORDER BY (k1);
;

insert into test select number as k1, cityHash64(number,10) as v1, cityHash64(number,2)%10 as p1, 1 as ver from numbers(10000000);
insert into test select number as k1, cityHash64(number,11) as v1, cityHash64(number,3)%10 as p1, 2 as ver from numbers(10000000);
insert into test select number as k1, cityHash64(number,12) as v1, cityHash64(number,4)%10 as p1, 3 as ver from numbers(10000000);

-- using argMax
select k1, sum(v1) totalSum
from (select k1, argMax(v1, ver) v1 from test group by k1)
group by k1 
order by totalSum desc
Limit 10;

-- using final
select k1, sum(v1) totalSum from test final group by k1
order by totalSum desc
Limit 10;