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