復制代碼 代碼如下:

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