applying filters with single column and all columns results are changing

[vihariazure]

hi team
i applied filter as 'price >2000' and output fields as ['price']
below are the results

now with the same filter and output fields as ['*']
below are the results

with price >2000 and output as all fields the price is column values are less then 2000 as you can use above attachment.
what is the reason for that results . how to fix it

[yhmo]

Possible reason: there are duplicate ids in the collection.
Did you insert two items with the same id 837291000? One item price is 2699, the other is 44.99?

[vihariazure]

thanks for the reply i will check and update