with test_CTE(id,salary)
as 
(
select id,max(salary)
from test
group by id 
)
select * from test_cte