sql - How to delete records with lower version in big query?

Question

Lets say my table contains the following data

id	name	version
1	Rahul	1
1	Rahul	2
2	John	1
3	Mike	1
2	John	2
4	Rubel	1
5	David	1
1	Rahul	3

Answer 1

For this dataset, aggregation seems sufficient:

select id, name, max(version) as max_version
from mytable
group by id, name