Neoview SQL Reference Manual (R2.3)

Examples of TRIM.........................................................................................................................429
UCASE Function.................................................................................................................................430
Considerations for UCASE............................................................................................................430
Examples of UCASE......................................................................................................................436
UPPER Function..................................................................................................................................438
Example of UPPER........................................................................................................................438
UPSHIFT Function..............................................................................................................................439
Examples of UPSHIFT...................................................................................................................439
USER Function....................................................................................................................................440
Example of USER...........................................................................................................................440
VARIANCE Function..........................................................................................................................441
Considerations for VARIANCE.....................................................................................................441
Definition of VARIANCE.........................................................................................................441
Data Type of the Result............................................................................................................442
Operands of the Expression.....................................................................................................442
Nulls.........................................................................................................................................442
FLOAT(54) and DOUBLE PRECISION Data............................................................................442
Examples of VARIANCE...............................................................................................................442
WEEK Function...................................................................................................................................443
Example of WEEK.........................................................................................................................443
YEAR Function....................................................................................................................................444
Example of YEAR..........................................................................................................................444
ZEROIFNULL Function......................................................................................................................445
Example of ZEROIFNULL.............................................................................................................445
7 OLAP Functions..........................................................................................................447
Considerations for Window Functions...............................................................................................447
AVG Window Function.......................................................................................................................447
Examples of AVG Window Function............................................................................................448
COUNT Window Function.................................................................................................................448
Examples of COUNT Window Function.......................................................................................449
DENSE_RANK Window Funtion.......................................................................................................449
Examples of DENSE_RANK Window Function...........................................................................450
MAX Window Function......................................................................................................................450
Examples of MAX Window Function............................................................................................450
MIN Window Function.......................................................................................................................451
Examples of MIN Window Function.............................................................................................451
RANK Window Function....................................................................................................................452
Examples of RANK Window Function.........................................................................................452
ROW_NUMBER Window Function...................................................................................................452
Examples of ROW_NUMBER Window Function.........................................................................453
STDDEV Window Function................................................................................................................453
Examples of STDDEV....................................................................................................................454
SUM Window Function......................................................................................................................454
Examples of SUM Window Function............................................................................................454
VARIANCE Function..........................................................................................................................455
Examples of VARIANCE...............................................................................................................456
A Quick Reference........................................................................................................457
B Reserved Words.........................................................................................................459
Reserved Neoview SQL Identifiers ....................................................................................................459
Table of Contents 19