Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^3: Adding numbers from a loop

by tweetiepooh (Hermit)
on Aug 07, 2019 at 11:58 UTC ( #11104091=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11104091]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (2)
As of 2022-08-08 05:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?