Neoview SQL Reference Manual (R2.4 SP2)

TAN Function......................................................................................................................................462
Example of TAN............................................................................................................................462
TANH Function...................................................................................................................................463
Example of TANH.........................................................................................................................463
THIS Function.....................................................................................................................................464
Considerations for THIS................................................................................................................464
Example of THIS............................................................................................................................464
TIMESTAMPADD Function................................................................................................................465
Examples of TIMESTAMPADD.....................................................................................................465
TIMESTAMPDIFF Function................................................................................................................466
Examples of TIMESTAMPDIFF.....................................................................................................466
TRANSLATE Function........................................................................................................................467
TRIM Function....................................................................................................................................468
Considerations for TRIM...............................................................................................................468
Examples of TRIM.........................................................................................................................468
UCASE Function.................................................................................................................................469
Considerations for UCASE............................................................................................................469
Examples of UCASE......................................................................................................................469
UPPER Function..................................................................................................................................470
Considerations for UPPER.............................................................................................................470
Example of UPPER........................................................................................................................470
UPSHIFT Function..............................................................................................................................471
Considerations for UPSHIFT.........................................................................................................471
Examples of UPSHIFT...................................................................................................................471
USER Function....................................................................................................................................472
Considerations for USER...............................................................................................................472
Example of USER...........................................................................................................................472
VARIANCE Function..........................................................................................................................473
Considerations for VARIANCE.....................................................................................................473
Examples of VARIANCE...............................................................................................................474
WEEK Function...................................................................................................................................475
Example of WEEK.........................................................................................................................475
YEAR Function....................................................................................................................................476
Example of YEAR..........................................................................................................................476
ZEROIFNULL Function......................................................................................................................477
Example of ZEROIFNULL.............................................................................................................477
7 OLAP Functions..........................................................................................................479
Considerations for Window Functions...............................................................................................479
ORDER BY Clause Supports Expressions For OLAP Functions...................................................479
Limitations for Window Functions................................................................................................480
AVG Window Function.......................................................................................................................481
Examples of AVG Window Function............................................................................................481
COUNT Window Function.................................................................................................................483
Examples of COUNT Window Function.......................................................................................483
DENSE_RANK Window Funtion.......................................................................................................485
Examples of DENSE_RANK Window Function...........................................................................485
MAX Window Function......................................................................................................................486
Examples of MAX Window Function............................................................................................486
MIN Window Function.......................................................................................................................488
Examples of MIN Window Function.............................................................................................488
RANK Window Function....................................................................................................................490
Examples of RANK Window Function.........................................................................................490
ROW_NUMBER Window Function...................................................................................................491
Table of Contents 15