Postgres 12

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

create table data (id int, name varchar, salary int)

CREATE TABLE


insert into data (id, name, salary)
select 1, 'John', 1000 union all
select 1, 'John', 10000 union all
select 2, 'Paul', 10000

INSERT 0 3


select distinct on ((id,name))
    id, name, salary
from data
order by (id,name), salary desc


id
name
salary


1
John
10000

2
Paul
10000



SELECT 2