Neoview SQL Reference Manual (R2.4)

POPULATE INDEX utility, 218
PURGEDATA, 219
V
Value expressions, 240
summary of, 323
CASE (Conditional) expression, 334
CAST expression, 337
VARCHAR data type, 234
Variable-length character column, 234
VARIANCE function
DISTINCT clause within, 475
examples of, 476
statistical definition of, 475
syntax diagram of, 475
VARIANCE window function
examples of, 497
syntax diagram of, 497
Vertical partition
example, 103
NOT ENFORCED constraint, 104
Views
CREATE VIEW statement, 99
description of, 292
DROP VIEW statement, 116
relationship to tables, 290
updatability requirements, 101
Volatile tables
considerations, 77
examples, 79, 89
nullable constraints, 78
nullable keys, 77
nullable primary key, 79
suitable keys, 78
W
WEEK function
example of, 477
syntax diagram of, 477
window functions
AVG , 483
considerations, 481
COUNT , 485
DENSE_RANK , 487
limitations, 482
MAX , 488
MIN , 490
RANK , 492
ROW_NUMBER, 493
STDDEV, 494
SUM, 495
VARIANCE, 497
Y
YEAR function
examples of, 478
syntax diagram of, 478
Z
ZEROIFNULL function
example of, 479
syntax diagram of, 479
529