Neoview SQL Reference Manual (R2.4)
using other materialized views, 64
Math functions
summary of, 320
ABS, 324
ACOS, 325
ASIN, 328
ATAN, 329
ATAN2, 330
CEILING, 339
COS, 348
COSH, 349
DEGREES, 374
EXP, 379
FLOOR, 384
LOG, 393
LOG10, 394
MOD, 405
PI, 422
POWER, 424
RADIANS, 426
ROUND, 433
SIGN, 447
SIN, 448
SINH, 449
SQRT, 451
TAN, 457
TANH, 458
ZEROIFNULL, 479
MAV
definition of, 63, 263
restrictions for, 65
MAX function
considerations for, 402
DISTINCT clause within, 402
examples of, 402
syntax diagram of, 402
MAX window function
examples of, 488
syntax diagram of, 488
MAXIMUM function
considerations for, 402
DISTINCT clause within, 402
examples of, 402
syntax diagram of, 402
MERGE INTO statement
description of, 149
example of, 151
merge from one table to another, 150
restrictions, 150
syntax diagram of, 149
upsert, single row, 149
MIN function
DISTINCT clause within, 403
examples of, 403
syntax diagram of, 403
MIN window function
examples of, 490
syntax diagram of, 490
MINUTE function
examples of, 404
syntax diagram of, 404
MJV
definition of, 63, 263
restrictions for, 65
MOD function
examples of, 405
syntax diagram of, 405
Mode_special_2, 513
MONTH function
examples of, 406
syntax diagram of, 406
MONTHNAME function
examples of, 407
syntax diagram of, 407
MOVINGAVG function
examples of, 408
syntax diagram of, 408
MOVINGCOUNT function
examples of, 409
syntax diagram of, 409
MOVINGMAX function
examples of, 410
syntax diagram of, 410
MOVINGMIN function
examples of, 411
syntax diagram of, 411
MOVINGSTDDEV function
examples of, 412
syntax diagram of, 412
MOVINGSUM function
examples of, 414
syntax diagram of, 414
MOVINGVARIANCE function
examples of, 415
syntax diagram of, 415
MVGROUP, definition of, 264
N
N string literals
character string literals, 256
NATIONAL CHAR data type, 234
NATIONAL CHAR VARYING data type, 234
National character set
N string literals, 256
NATURAL join, description of, 168
NATURAL LEFT join, description of, 168
NATURAL RIGHT join, description of, 168
NCHAR data type
description of, 234
NCHAR VARYING data type, 234
Neoview SQL objects, logical names, 228
NOT CASESPECIFIC, 75
NOT ENFORCED constraint, 104
NOT NULL constraint, 225
NULL predicate
examples of, 278
syntax diagram of, 277
Null symbol, 265
523