SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-59
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.