1.select AAC001,sum(AAC004)
from temp1
group by AAC0012.
select * from (select row_number()over(order by AAC002 desc) rn,a.*
from temp1 a
) where rn =1
from temp1
group by AAC0012.
select * from (select row_number()over(order by AAC002 desc) rn,a.*
from temp1 a
) where rn =1
from
(select AAC001,AAC002,AAC003,AAC004,
row_number() over(partition by AAC001 order by AAC002 desc) t
from temp1)
where t=1