how to select max two from each group in sql code example

Example: SQL get max per id

select name, max(value)
from out_pumptable
group by name