Neoview SQL Reference Manual (R2.5)

Example of LTRIM.........................................................................................................................418
MAX/MAXIMUM Function................................................................................................................419
Considerations for MAX/MAXIMUM...........................................................................................419
Example of MAX/MAXIMUM.......................................................................................................419
MIN Function......................................................................................................................................420
Considerations for MIN.................................................................................................................420
Example of MIN.............................................................................................................................420
MINUTE Function...............................................................................................................................421
Example of MINUTE.....................................................................................................................421
MOD Function....................................................................................................................................422
Example of MOD...........................................................................................................................422
MONTH Function...............................................................................................................................423
Example of MONTH......................................................................................................................423
MONTHNAME Function...................................................................................................................424
Considerations for MONTHNAME..............................................................................................424
Example of MONTHNAME..........................................................................................................424
MOVINGAVG Function......................................................................................................................425
Example of MOVINGAVG............................................................................................................425
MOVINGCOUNT Function................................................................................................................426
Considerations for MOVINGCOUNT...........................................................................................426
Example of MOVINGCOUNT.......................................................................................................426
MOVINGMAX Function.....................................................................................................................427
Example of MOVINGMAX...........................................................................................................427
MOVINGMIN Function......................................................................................................................428
Example of MOVINGMIN............................................................................................................428
MOVINGSTDDEV Function...............................................................................................................429
Example of MOVINGSTDDEV......................................................................................................429
MOVINGSUM Function.....................................................................................................................431
Example of MOVINGSUM............................................................................................................431
MOVINGVARIANCE Function..........................................................................................................432
Example of MOVINGVARIANCE.................................................................................................432
NULLIF Function................................................................................................................................434
Example of NULLIF.......................................................................................................................434
NULLIFZERO Function......................................................................................................................435
Examples of NULLIFZERO...........................................................................................................435
NVL Function......................................................................................................................................436
Examples of NVL...........................................................................................................................436
OCTET_LENGTH Function................................................................................................................437
Considerations for OCTET_LENGTH...........................................................................................437
Example of OCTET_LENGTH.......................................................................................................437
OFFSET Function................................................................................................................................438
Example of OFFSET.......................................................................................................................438
PI Function..........................................................................................................................................439
Example of PI.................................................................................................................................439
POSITION Function............................................................................................................................440
Considerations for POSITION.......................................................................................................440
Examples of POSITION.................................................................................................................440
POWER Function................................................................................................................................441
Examples of POWER.....................................................................................................................441
QUARTER Function............................................................................................................................442
Example of QUARTER..................................................................................................................442
RADIANS Function............................................................................................................................443
Examples of RADIANS..................................................................................................................443
RANK/RUNNINGRANK Function....................................................................................................444
Considerations for RANK/RUNNINGRANK...............................................................................444
Table of Contents 13