Duda consulta SQL

[straw]

Gracias, me sirve, otra forma sería:

Código:

select * from tabla t1 join 
(select max(version) as version, num_oferta from tabla group by num_oferta) t2 
on t2.num_oferta = t1.num_oferta and t2.version = t1.version