create table test (id int, version int) engine = ReplacingMergeTree order by id;

insert into test values (1, 1);
insert into test values (1, 2);

select * from test final where id = 1 and version = 1; -- empty result
select * from test final prewhere id = 1 and version = 1; -- returns (1, 1)