SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxv
9. SQL/MX Functions and Expressions
Examples of MONTHNAME 9-103
MOVINGAVG Function 9-104
Examples of MOVINGAVG 9-105
MOVINGCOUNT Function 9-106
Considerations for MOVINGCOUNT 9-107
Examples of MOVINGCOUNT 9-107
MOVINGMAX Function 9-108
Examples of MOVINGMAX 9-109
MOVINGMIN Function 9-110
Examples of MOVINGMIN 9-111
MOVINGSTDDEV Function 9-112
Examples of MOVINGSTDDEV 9-113
MOVINGSUM Function 9-114
Examples of MOVINGSUM 9-115
MOVINGVARIANCE Function 9-116
Examples of MOVINGVARIANCE 9-117
NVL Function 9-118
Considerations 9-118
Example of NVL 9-119
NVL2 Function 9-120
Considerations 9-120
Examples of NVL2 9-120
OCTET_LENGTH Function 9-121
Considerations for OCTET_LENGTH 9-121
Examples of OCTET_LENGTH 9-122
OFFSET Function 9-123
Examples of OFFSET
9-123
PI Function 9-125
Examples of PI 9-125
POSITION Function
9-126
Considerations for POSITION
9-126
Examples of POSITION 9-127
POWER Function
9-127
Examples of POWER
9-127
QUARTER Function
9-128
Examples of QUARTER
9-128
QUERYCACHE Function 9-129
Considerations for QUERYCACHE
9-129
Examples of QUERYCACHE 9-131