try this one
select name,MAX(id) as [ID],MAX(amount) as[MAXIMUM AMOUNT] from testtest
group by name
this will give you the output that you have desired
And there is an entry wrong in the insert statement that you have written. First entry must be insert into testtest values(1,'aa',100) instead of (3,'aa',100)