Neoview SQL Reference Manual (R2.4)

MOVINGAVG Function......................................................................................................................408
Example of MOVINGAVG............................................................................................................408
MOVINGCOUNT Function................................................................................................................409
Considerations for MOVINGCOUNT...........................................................................................409
Example of MOVINGCOUNT.......................................................................................................409
MOVINGMAX Function.....................................................................................................................410
Example of MOVINGMAX...........................................................................................................410
MOVINGMIN Function......................................................................................................................411
Example of MOVINGMIN............................................................................................................411
MOVINGSTDDEV Function...............................................................................................................412
Example of MOVINGSTDDEV......................................................................................................412
MOVINGSUM Function.....................................................................................................................414
Example of MOVINGSUM............................................................................................................414
MOVINGVARIANCE Function..........................................................................................................415
Example of MOVINGVARIANCE.................................................................................................415
NULLIF Function................................................................................................................................417
Example of NULLIF.......................................................................................................................417
NULLIFZERO Function......................................................................................................................418
Examples of NULLIFZERO...........................................................................................................418
NVL Function......................................................................................................................................419
Examples of NVL...........................................................................................................................419
OCTET_LENGTH Function................................................................................................................420
Considerations for OCTET_LENGTH...........................................................................................420
Example of OCTET_LENGTH.......................................................................................................420
OFFSET Function................................................................................................................................421
Example of OFFSET.......................................................................................................................421
PI Function..........................................................................................................................................422
Example of PI.................................................................................................................................422
POSITION Function............................................................................................................................423
Considerations for POSITION.......................................................................................................423
Examples of POSITION.................................................................................................................423
POWER Function................................................................................................................................424
Examples of POWER.....................................................................................................................424
QUARTER Function............................................................................................................................425
Example of QUARTER..................................................................................................................425
RADIANS Function............................................................................................................................426
Examples of RADIANS..................................................................................................................426
RANK/RUNNINGRANK Function....................................................................................................427
Considerations for RANK/RUNNINGRANK...............................................................................427
Examples of RANK/RUNNINGRANK.........................................................................................427
REPEAT Function................................................................................................................................430
Example of REPEAT......................................................................................................................430
REPLACE Function.............................................................................................................................431
Example of REPLACE...................................................................................................................431
RIGHT Function..................................................................................................................................432
Examples of RIGHT.......................................................................................................................432
ROUND Function................................................................................................................................433
Examples of ROUND.....................................................................................................................433
ROWS SINCE Function.......................................................................................................................434
Considerations for ROWS SINCE..................................................................................................434
Examples of ROWS SINCE............................................................................................................434
ROWS SINCE CHANGED Function..................................................................................................436
Considerations for ROWS SINCE CHANGED.............................................................................436
Examples of ROWS SINCE CHANGED........................................................................................436
RPAD Function...................................................................................................................................437
Table of Contents 13