SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-151

Example of THIS

The table SEQFCN has columns I1 and TS with data that is sequenced by column TS:

•

Return the number of rows since the condition I1 less than a previous row became

true:

SELECT ROWS SINCE (THIS(I1) < I1) AS ROWS_SINCE_THIS

FROM mining.seqfcn

SEQUENCE BY TS;

ROWS_SINCE_THIS

---------------

--- 5 row(s) selected.

I1 TS

6215 TIMESTAMP '1950-03-05 08:32:09'

28174 TIMESTAMP '1951-02-15 14:35:49'

19058 TIMESTAMP '1955-05-18 08:40:10'

4597 TIMESTAMP '1960-09-19 14:40:39'

31966 TIMESTAMP '1964-05-01 16:41:02'