Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table application_version (id int, version int, application_id int);


  
  
insert into application_version (id, version, application_id) values
  (10, 100, 1),
  (11, 101, 2),
  (20, 500, 1),
  (21, 501, 2);
4 rows affected

select distinct on (application_id) *
from application_version
order by application_id, version desc


id
version
application_id


20
500
1

21
501
2