Neoview SQL Reference Manual (R2.3)

Similarity to CHAR_LENGTH Function..................................................................................391
Example of OCTET_LENGTH.......................................................................................................391
OFFSET Function................................................................................................................................392
Example of OFFSET.......................................................................................................................392
PI Function..........................................................................................................................................393
Example of PI.................................................................................................................................393
POSITION Function............................................................................................................................394
Considerations for POSITION.......................................................................................................394
Result of POSITION.................................................................................................................394
Using the UPSHIFT Function...................................................................................................394
Examples of POSITION.................................................................................................................394
POWER Function................................................................................................................................395
Examples of POWER.....................................................................................................................395
QUARTER Function............................................................................................................................396
Example of QUARTER..................................................................................................................396
RADIANS Function............................................................................................................................397
Examples of RADIANS..................................................................................................................397
RANK/RUNNINGRANK Function....................................................................................................398
Considerations for RUNNINGRANK...........................................................................................398
Depends of the Sequence order................................................................................................398
NULL Values............................................................................................................................398
Examples of RUNNINGRANK.....................................................................................................398
RUNNINGSTDDEV Function............................................................................................................400
Considerations for RUNNINGSTDDEV.......................................................................................400
Equivalent Result......................................................................................................................400
Examples of RUNNINGSTDDEV..................................................................................................400
REPEAT Function................................................................................................................................401
Example of REPEAT......................................................................................................................401
REPLACE Function.............................................................................................................................401
Example of REPLACE...................................................................................................................402
RIGHT Function..................................................................................................................................402
Examples of RIGHT.......................................................................................................................402
ROUND Function................................................................................................................................403
Examples of ROUND.....................................................................................................................403
ROWS SINCE Function.......................................................................................................................403
Considerations for ROWS SINCE..................................................................................................404
Counting the Rows...................................................................................................................404
Examples of ROWS SINCE............................................................................................................404
ROWS SINCE CHANGED Function..................................................................................................405
Considerations for ROWS SINCE CHANGED.............................................................................405
Counting the Rows...................................................................................................................405
Examples of ROWS SINCE CHANGED........................................................................................405
RPAD Function...................................................................................................................................405
RTRIM Function..................................................................................................................................406
Considerations for RTRIM.............................................................................................................406
Result of RTRIM.......................................................................................................................406
Example of RTRIM........................................................................................................................406
RUNNINGAVG Function...................................................................................................................406
Considerations for RUNNINGAVG..............................................................................................407
Equivalent Result......................................................................................................................407
Example of RUNNINGAVG..........................................................................................................407
RUNNINGCOUNT Function..............................................................................................................407
Considerations for RUNNINGCOUNT........................................................................................407
No DISTINCT Clause...............................................................................................................407
Example of RUNNINGCOUNT....................................................................................................407
Table of Contents 17