Neoview SQL Reference Manual (R2.4)

TRANSLATE Function........................................................................................................................462
TRIM Function....................................................................................................................................463
Considerations for TRIM...............................................................................................................463
Examples of TRIM.........................................................................................................................463
UCASE Function.................................................................................................................................464
Considerations for UCASE............................................................................................................464
Examples of UCASE......................................................................................................................471
UPPER Function..................................................................................................................................472
Considerations for UPPER.............................................................................................................472
Example of UPPER........................................................................................................................472
UPSHIFT Function..............................................................................................................................473
Considerations for UPSHIFT.........................................................................................................473
Examples of UPSHIFT...................................................................................................................473
USER Function....................................................................................................................................474
Considerations for USER...............................................................................................................474
Example of USER...........................................................................................................................474
VARIANCE Function..........................................................................................................................475
Considerations for VARIANCE.....................................................................................................475
Examples of VARIANCE...............................................................................................................476
WEEK Function...................................................................................................................................477
Example of WEEK.........................................................................................................................477
YEAR Function....................................................................................................................................478
Example of YEAR..........................................................................................................................478
ZEROIFNULL Function......................................................................................................................479
Example of ZEROIFNULL.............................................................................................................479
7 OLAP Functions..........................................................................................................481
Considerations for Window Functions...............................................................................................481
ORDER BY Clause Supports Expressions For OLAP Functions...................................................481
Limitations for Window Functions................................................................................................482
AVG Window Function.......................................................................................................................483
Examples of AVG Window Function............................................................................................483
COUNT Window Function.................................................................................................................485
Examples of COUNT Window Function.......................................................................................485
DENSE_RANK Window Funtion.......................................................................................................487
Examples of DENSE_RANK Window Function...........................................................................487
MAX Window Function......................................................................................................................488
Examples of MAX Window Function............................................................................................488
MIN Window Function.......................................................................................................................490
Examples of MIN Window Function.............................................................................................490
RANK Window Function....................................................................................................................492
Examples of RANK Window Function.........................................................................................492
ROW_NUMBER Window Function...................................................................................................493
Examples of ROW_NUMBER Window Function.........................................................................493
STDDEV Window Function................................................................................................................494
Examples of STDDEV....................................................................................................................494
SUM Window Function......................................................................................................................495
Examples of SUM Window Function............................................................................................495
VARIANCE Function..........................................................................................................................497
Examples of VARIANCE...............................................................................................................497
Table of Contents 15