Neoview SQL Reference Manual (R2.5)

Examples of RANK/RUNNINGRANK.........................................................................................444
REPEAT Function................................................................................................................................447
Example of REPEAT......................................................................................................................447
REPLACE Function.............................................................................................................................448
Example of REPLACE...................................................................................................................448
RIGHT Function..................................................................................................................................449
Examples of RIGHT.......................................................................................................................449
ROUND Function................................................................................................................................450
Examples of ROUND.....................................................................................................................450
ROWS SINCE Function.......................................................................................................................451
Considerations for ROWS SINCE..................................................................................................451
Examples of ROWS SINCE............................................................................................................451
ROWS SINCE CHANGED Function..................................................................................................453
Considerations for ROWS SINCE CHANGED.............................................................................453
Examples of ROWS SINCE CHANGED........................................................................................453
RPAD Function...................................................................................................................................454
Examples of RPAD Function.........................................................................................................454
RTRIM Function..................................................................................................................................455
Considerations for RTRIM.............................................................................................................455
Example of RTRIM........................................................................................................................455
RUNNINGAVG Function...................................................................................................................456
Considerations for RUNNINGAVG..............................................................................................456
Example of RUNNINGAVG..........................................................................................................456
RUNNINGCOUNT Function..............................................................................................................457
Considerations for RUNNINGCOUNT........................................................................................457
Example of RUNNINGCOUNT....................................................................................................457
RUNNINGMAX Function..................................................................................................................458
Example of RUNNINGMAX.........................................................................................................458
RUNNINGMIN Function...................................................................................................................459
Example of RUNNINGMIN..........................................................................................................459
RUNNINGRANK Function................................................................................................................459
RUNNINGSTDDEV Function............................................................................................................460
Considerations for RUNNINGSTDDEV.......................................................................................460
Examples of RUNNINGSTDDEV..................................................................................................460
RUNNINGSUM Function...................................................................................................................461
Example of RUNNINGSUM..........................................................................................................461
RUNNINGVARIANCE Function........................................................................................................462
Examples of RUNNINGVARIANCE.............................................................................................462
SECOND Function..............................................................................................................................463
Example of SECOND.....................................................................................................................463
SIGN Function.....................................................................................................................................464
Examples of SIGN..........................................................................................................................464
SIN Function.......................................................................................................................................465
Example of SIN..............................................................................................................................465
SINH Function....................................................................................................................................466
Example of SINH...........................................................................................................................466
SPACE Function..................................................................................................................................467
Example of SPACE.........................................................................................................................467
SQRT Function....................................................................................................................................468
Example of SQRT...........................................................................................................................468
STDDEV Function...............................................................................................................................469
Considerations for STDDEV..........................................................................................................469
Examples of STDDEV....................................................................................................................470
SUBSTRING/SUBSTR Function..........................................................................................................471
Alternative Forms..........................................................................................................................471
14 Table of Contents