Neoview SQL Reference Manual (R2.4)

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