SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
8-129
Examples of OFFSET
•
Retrieve the I1 column offset by three rows:
SELECT OFFSET (I1,3) AS OFFSET3
FROM mining.seqfcn
SEQUENCE BY TS;
OFFSET3
------------
?
?
?
6215
28174
--- 5 row(s) selected.
Note that the first three rows retrieved display null because the offset from the
current row does not fall within the result table.