Neoview SQL Reference Manual (R2.4 SP2)

Considerations for MIN.................................................................................................................408
Example of MIN.............................................................................................................................408
MINUTE Function...............................................................................................................................409
Example of MINUTE.....................................................................................................................409
MOD Function....................................................................................................................................410
Example of MOD...........................................................................................................................410
MONTH Function...............................................................................................................................411
Example of MONTH......................................................................................................................411
MONTHNAME Function...................................................................................................................412
Considerations for MONTHNAME..............................................................................................412
Example of MONTHNAME..........................................................................................................412
MOVINGAVG Function......................................................................................................................413
Example of MOVINGAVG............................................................................................................413
MOVINGCOUNT Function................................................................................................................414
Considerations for MOVINGCOUNT...........................................................................................414
Example of MOVINGCOUNT.......................................................................................................414
MOVINGMAX Function.....................................................................................................................415
Example of MOVINGMAX...........................................................................................................415
MOVINGMIN Function......................................................................................................................416
Example of MOVINGMIN............................................................................................................416
MOVINGSTDDEV Function...............................................................................................................417
Example of MOVINGSTDDEV......................................................................................................417
MOVINGSUM Function.....................................................................................................................419
Example of MOVINGSUM............................................................................................................419
MOVINGVARIANCE Function..........................................................................................................420
Example of MOVINGVARIANCE.................................................................................................420
NULLIF Function................................................................................................................................422
Example of NULLIF.......................................................................................................................422
NULLIFZERO Function......................................................................................................................423
Examples of NULLIFZERO...........................................................................................................423
NVL Function......................................................................................................................................424
Examples of NVL...........................................................................................................................424
OCTET_LENGTH Function................................................................................................................425
Considerations for OCTET_LENGTH...........................................................................................425
Example of OCTET_LENGTH.......................................................................................................425
OFFSET Function................................................................................................................................426
Example of OFFSET.......................................................................................................................426
PI Function..........................................................................................................................................427
Example of PI.................................................................................................................................427
POSITION Function............................................................................................................................428
Considerations for POSITION.......................................................................................................428
Examples of POSITION.................................................................................................................428
POWER Function................................................................................................................................429
Examples of POWER.....................................................................................................................429
QUARTER Function............................................................................................................................430
Example of QUARTER..................................................................................................................430
RADIANS Function............................................................................................................................431
Examples of RADIANS..................................................................................................................431
RANK/RUNNINGRANK Function....................................................................................................432
Considerations for RANK/RUNNINGRANK...............................................................................432
Examples of RANK/RUNNINGRANK.........................................................................................432
REPEAT Function................................................................................................................................435
Example of REPEAT......................................................................................................................435
REPLACE Function.............................................................................................................................436
Example of REPLACE...................................................................................................................436
Table of Contents 13