Neoview SQL Reference Manual (R2.4 SP2)

RIGHT Function..................................................................................................................................437
Examples of RIGHT.......................................................................................................................437
ROUND Function................................................................................................................................438
Examples of ROUND.....................................................................................................................438
ROWS SINCE Function.......................................................................................................................439
Considerations for ROWS SINCE..................................................................................................439
Examples of ROWS SINCE............................................................................................................439
ROWS SINCE CHANGED Function..................................................................................................441
Considerations for ROWS SINCE CHANGED.............................................................................441
Examples of ROWS SINCE CHANGED........................................................................................441
RPAD Function...................................................................................................................................442
Examples of RPAD Function.........................................................................................................442
RTRIM Function..................................................................................................................................443
Considerations for RTRIM.............................................................................................................443
Example of RTRIM........................................................................................................................443
RUNNINGAVG Function...................................................................................................................444
Considerations for RUNNINGAVG..............................................................................................444
Example of RUNNINGAVG..........................................................................................................444
RUNNINGCOUNT Function..............................................................................................................445
Considerations for RUNNINGCOUNT........................................................................................445
Example of RUNNINGCOUNT....................................................................................................445
RUNNINGMAX Function..................................................................................................................446
Example of RUNNINGMAX.........................................................................................................446
RUNNINGMIN Function...................................................................................................................447
Example of RUNNINGMIN..........................................................................................................447
RUNNINGRANK Function................................................................................................................447
RUNNINGSTDDEV Function............................................................................................................448
Considerations for RUNNINGSTDDEV.......................................................................................448
Examples of RUNNINGSTDDEV..................................................................................................448
RUNNINGSUM Function...................................................................................................................449
Example of RUNNINGSUM..........................................................................................................449
RUNNINGVARIANCE Function........................................................................................................450
Examples of RUNNINGVARIANCE.............................................................................................450
SECOND Function..............................................................................................................................451
Example of SECOND.....................................................................................................................451
SIGN Function.....................................................................................................................................452
Examples of SIGN..........................................................................................................................452
SIN Function.......................................................................................................................................453
Example of SIN..............................................................................................................................453
SINH Function....................................................................................................................................454
Example of SINH...........................................................................................................................454
SPACE Function..................................................................................................................................455
Example of SPACE.........................................................................................................................455
SQRT Function....................................................................................................................................456
Example of SQRT...........................................................................................................................456
STDDEV Function...............................................................................................................................457
Considerations for STDDEV..........................................................................................................457
Examples of STDDEV....................................................................................................................458
SUBSTRING/SUBSTR Function..........................................................................................................459
Alternative Forms..........................................................................................................................459
Considerations for SUBSTRING/SUBSTR.....................................................................................459
Examples of SUBSTRING/SUBSTR...............................................................................................460
SUM Function.....................................................................................................................................461
Considerations for SUM................................................................................................................461
Example of SUM............................................................................................................................461
14 Table of Contents