SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-148

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.