Neoview SQL Reference Manual (R2.5)

MIN Window Function.......................................................................................................................500
Examples of MIN Window Function.............................................................................................500
RANK Window Function....................................................................................................................502
Examples of RANK Window Function.........................................................................................502
ROW_NUMBER Window Function...................................................................................................503
Examples of ROW_NUMBER Window Function.........................................................................503
STDDEV Window Function................................................................................................................504
Examples of STDDEV....................................................................................................................504
SUM Window Function......................................................................................................................505
Examples of SUM Window Function............................................................................................505
VARIANCE Window Function...........................................................................................................507
Examples of VARIANCE Window Function.................................................................................507
A Mapping Tables........................................................................................................509
B Reserved Words.........................................................................................................519
Reserved Neoview SQL Identifiers ....................................................................................................519
C Limits...........................................................................................................................523
D Standard SQL and Neoview SQL............................................................................525
ANSI SQL Standards...........................................................................................................................525
ISO Standards......................................................................................................................................525
Neoview SQL Compliance..................................................................................................................526
Neoview SQL Extensions to Standard SQL........................................................................................529
Character Set Support.........................................................................................................................529
E Special Neoview Features—Enabled Upon Request..............................................531
Mode_Special_2..................................................................................................................................531
Features Supported in Mode_Special_2........................................................................................532
Index...............................................................................................................................535
16 Table of Contents