SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxvi
9. SQL/MX Functions and Expressions
Examples of MOVINGCOUNT 9-112
MOVINGMAX Function 9-113
Examples of MOVINGMAX 9-114
MOVINGMIN Function 9-115
Examples of MOVINGMIN 9-116
MOVINGSTDDEV Function 9-117
Examples of MOVINGSTDDEV 9-118
MOVINGSUM Function 9-119
Examples of MOVINGSUM 9-120
MOVINGVARIANCE Function 9-121
Examples of MOVINGVARIANCE 9-122
NVL Function 9-123
Considerations 9-123
Example of NVL 9-124
NVL2 Function 9-125
Considerations 9-125
Examples of NVL2 9-125
OCTET_LENGTH Function 9-126
Considerations for OCTET_LENGTH 9-126
Examples of OCTET_LENGTH 9-127
OFFSET Function 9-128
Examples of OFFSET 9-128
PI Function 9-130
Examples of PI 9-130
POSITION Function 9-131
Considerations for POSITION 9-131
Examples of POSITION
9-132
POWER Function 9-132
Examples of POWER 9-132
QUARTER Function
9-133
Examples of QUARTER
9-133
QUERYCACHE Function 9-134
Considerations for QUERYCACHE
9-134
Examples of QUERYCACHE
9-136
QUERYCACHEENTRIES Function
9-138
Considerations for QUERYCACHEENTRIES
9-138
Examples of QUERYCACHEENTRIES 9-140
RADIANS Function
9-143
Examples of RADIANS 9-143