SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

9-177

Examples of SUM



Compute the total value of parts in the current inventory:

SELECT SUM (price * qty_available)

FROM sales.parts;

(EXPR)

---------------------

117683505.96

--- 1 row(s) selected.