in reply to Re^2: Adding numbers from a loop
in thread Adding numbers from a loop
Does your database have a lookup type function that will translate for you then you can use SUM. This is for Oracle and may not be the best alternative even there.
select sum(decode(total,3,30,6,48,10,50,0)) from table
|
|---|