SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xl
8. SQL/MX Functions and Expressions
Examples of RADIANS 8-143
RELATEDNESS Function 8-144
Example of RELATEDNESS 8-144
REPEAT Function 8-145
Examples of REPEAT 8-145
REPLACE Function 8-146
Examples of REPLACE 8-146
RIGHT Function 8-147
Examples of RIGHT 8-147
ROWS SINCE Function 8-148
Considerations for ROWS SINCE 8-148
Counting the Rows 8-148
Examples of ROWS SINCE 8-149
RPAD Function 8-150
Examples of RPAD 8-150
RTRIM Function 8-152
Considerations for RTRIM 8-152
Result of RTRIM 8-152
Examples of RTRIM 8-152
RUNNINGAVG Function 8-153
Considerations for RUNNINGAVG 8-153
Equivalent Result 8-153
Examples of RUNNINGAVG 8-153
RUNNINGCOUNT Function 8-155
Considerations for RUNNINGCOUNT 8-155
No DISTINCT Clause 8-155
Examples of RUNNINGCOUNT
8-155
RUNNINGMAX Function 8-157
Examples of RUNNINGMAX 8-157
RUNNINGMIN Function
8-159
Examples of RUNNINGMIN
8-159
RUNNINGSTDDEV Function 8-161
Considerations for RUNNINGSTDDEV
8-161
Equivalent Result
8-161
Examples of RUNNINGSTDDEV
8-161
RUNNINGSUM Function
8-163
Examples of RUNNINGSUM 8-163
RUNNINGVARIANCE Function
8-165
Examples of RUNNINGVARIANCE 8-165