Neoview SQL Reference Manual (R2.2)

Examples of RUNNINGSTDDEV..................................................................................................389
REPEAT Function................................................................................................................................390
Example of REPEAT......................................................................................................................390
REPLACE Function.............................................................................................................................390
Example of REPLACE...................................................................................................................391
RIGHT Function..................................................................................................................................391
Examples of RIGHT.......................................................................................................................391
ROUND Function................................................................................................................................392
Examples of ROUND.....................................................................................................................392
ROWS SINCE Function.......................................................................................................................392
Considerations for ROWS SINCE..................................................................................................393
Counting the Rows...................................................................................................................393
Examples of ROWS SINCE............................................................................................................393
ROWS SINCE CHANGED Function..................................................................................................394
Considerations for ROWS SINCE CHANGED.............................................................................394
Counting the Rows...................................................................................................................394
Examples of ROWS SINCE CHANGED........................................................................................394
RPAD Function...................................................................................................................................394
RTRIM Function..................................................................................................................................395
Considerations for RTRIM.............................................................................................................395
Result of RTRIM.......................................................................................................................395
Example of RTRIM........................................................................................................................395
RUNNINGAVG Function...................................................................................................................395
Considerations for RUNNINGAVG..............................................................................................396
Equivalent Result......................................................................................................................396
Example of RUNNINGAVG..........................................................................................................396
RUNNINGCOUNT Function..............................................................................................................396
Considerations for RUNNINGCOUNT........................................................................................396
No DISTINCT Clause...............................................................................................................396
Example of RUNNINGCOUNT....................................................................................................396
RUNNINGMAX Function..................................................................................................................397
Example of RUNNINGMAX.........................................................................................................397
RUNNINGMIN Function...................................................................................................................397
Example of RUNNINGMIN..........................................................................................................397
RUNNINGRANK Function................................................................................................................399
RUNNINGSTDDEV Function............................................................................................................400
Considerations for RUNNINGSTDDEV.......................................................................................400
Equivalent Result......................................................................................................................400
Examples of RUNNINGSTDDEV..................................................................................................400
RUNNINGSUM Function...................................................................................................................401
Example of RUNNINGSUM..........................................................................................................401
RUNNINGVARIANCE Function........................................................................................................402
Examples of RUNNINGVARIANCE.............................................................................................402
SECOND Function..............................................................................................................................403
Example of SECOND.....................................................................................................................403
SIGN Function.....................................................................................................................................404
Examples of SIGN..........................................................................................................................404
SIN Function.......................................................................................................................................405
Example of SIN..............................................................................................................................405
SINH Function....................................................................................................................................406
Example of SINH...........................................................................................................................406
SPACE Function..................................................................................................................................407
Example of SPACE.........................................................................................................................407
SQRT Function....................................................................................................................................408
Example of SQRT...........................................................................................................................408
Table of Contents 17