Neoview SQL Reference Manual (R2.2)

Note that the results are equal to the difference of DIFF1(I1) for the current row and DIFF1(I1)
of the previous row. For example, in the third row of the output of this example, -31075 is
equal to -9116 minus 21959. The value -9116 is the result of DIFF1(I1) for the current row,
and the value 21959 is the result of DIFF1(I1) for the previous row. See “Examples of DIFF1”
(page 334).
• 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.
DIFF2 Function 337