SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—640322-001

9-159

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.