SQL/MX 2.x Reference Manual (H06.04+)
SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-50
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.