select 
    name, 
    sum(value) as sumval 
  from mytable
  group by name
  order by abs(sumval) desc

##</code><code>##

  order by abs(2) desc