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-64
Examples of DIFF2
•
Retrieve the difference in consecutive values of DIFF1(I1) divided by the difference
in consecutive values of TS:
SELECT DIFF2 (I1,TS) AS DIFF2_I1TS
FROM mining.seqfcn
SEQUENCE BY TS;
DIFF2_I1TS
---------------------
?
?
-.000231
-.000031
.000191
--- 5 row(s) selected.