Neoview SQL Reference Manual (R2.5)

Considerations for SUBSTRING/SUBSTR.....................................................................................471
Examples of SUBSTRING/SUBSTR...............................................................................................472
SUM Function.....................................................................................................................................473
Considerations for SUM................................................................................................................473
Example of SUM............................................................................................................................473
TAN Function......................................................................................................................................474
Example of TAN............................................................................................................................474
TANH Function...................................................................................................................................475
Example of TANH.........................................................................................................................475
THIS Function.....................................................................................................................................476
Considerations for THIS................................................................................................................476
Example of THIS............................................................................................................................476
TIMESTAMPADD Function................................................................................................................477
Examples of TIMESTAMPADD.....................................................................................................477
TIMESTAMPDIFF Function................................................................................................................478
Examples of TIMESTAMPDIFF.....................................................................................................478
TRANSLATE Function........................................................................................................................479
TRIM Function....................................................................................................................................480
Considerations for TRIM...............................................................................................................480
Examples of TRIM.........................................................................................................................480
UCASE Function.................................................................................................................................481
Considerations for UCASE............................................................................................................481
Examples of UCASE......................................................................................................................481
UPPER Function..................................................................................................................................482
Considerations for UPPER.............................................................................................................482
Example of UPPER........................................................................................................................482
UPSHIFT Function..............................................................................................................................483
Considerations for UPSHIFT.........................................................................................................483
Examples of UPSHIFT...................................................................................................................483
USER Function....................................................................................................................................484
Considerations for USER...............................................................................................................484
Example of USER...........................................................................................................................484
VARIANCE Function..........................................................................................................................485
Considerations for VARIANCE.....................................................................................................485
Examples of VARIANCE...............................................................................................................486
WEEK Function...................................................................................................................................487
Example of WEEK.........................................................................................................................487
YEAR Function....................................................................................................................................488
Example of YEAR..........................................................................................................................488
ZEROIFNULL Function......................................................................................................................489
Example of ZEROIFNULL.............................................................................................................489
7 OLAP Functions..........................................................................................................491
Considerations for Window Functions...............................................................................................491
ORDER BY Clause Supports Expressions For OLAP Functions...................................................491
Limitations for Window Functions................................................................................................492
AVG Window Function.......................................................................................................................493
Examples of AVG Window Function............................................................................................493
COUNT Window Function.................................................................................................................495
Examples of COUNT Window Function.......................................................................................495
DENSE_RANK Window Funtion.......................................................................................................497
Examples of DENSE_RANK Window Function...........................................................................497
MAX Window Function......................................................................................................................498
Examples of MAX Window Function............................................................................................498
Table of Contents 15