Lets say my table contains the following data
For this dataset, aggregation seems sufficient:
select id, name, max(version) as max_version from mytable group by id, name
548k questions
547k answers
4 comments
56.1k users