SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004

8-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.