There is a function SUM, which will add a column and give you a total.



Is there a similar function for multiplication?



For a query, I need to select (multiple sets based on specific criteria)
two values, multiply them to receive an amount, then sum the values to
see if the total exceeds a specified amount.



I'm just wondering if there is an easier way then setting up multiple
select statements .... Any advice you can offer would be appreciated.



Thank you,





Richard N. Olsen

Database Administrator

SC Department of Disabilities & Special Needs

Phone: (803) 898-9811

Email: [Email address protected]




DB2 & UDB email list listserv db2-l LazyDBA home page