Neoview SQL Reference Manual (R2.4)

syntax diagram of, 440
RUNNINGMAX function
examples of, 441
syntax diagram of, 441
RUNNINGMIN function
examples of, 442
syntax diagram of, 442
RUNNINGRANK function
considerations for, 427
example for, 427
syntax diagram of, 427
RUNNINGSTDDEV function
equivalent definition, 443
examples of, 443
syntax diagram of, 443
RUNNINGSUM function
examples of, 444
syntax diagram of, 444
RUNNINGVARIANCE function
examples of, 445
syntax diagram of, 445
S
SAMPLE clause
cluster sampling, 300
examples of, 300
SELECT statement use of, 298
syntax diagram of, 298
Sampling, clusters, 300
Scale, 251
Schemas
description of, 285
reserved for HP, 68
Search condition
Boolean operators within, 286
CASE expression use of, 334
DELETE statement use of, 106
description of, 288
examples of, 287
predicate within, 286
syntax diagram of, 286
UPDATE statement use of, 198
SECOND function
examples of, 446
syntax diagram of, 446
SELECT statement
access options, 171
authorization requirements, 172
DISTINCT clause , 165
embedded delete, 166
embedded insert, 168
embedded update, 167, 168
examples of, 177
FROM clause , 166
GROUP BY clause , 170, 174
HAVING clause, 171
joined table within, 168
lock modes, 171
ORDER BY clause , 172, 175
RETURN list, 167
select list elements, 165
SEQUENCE BY clause, 170
simple table within, 168
SKIP CONFLICT access, 171
stream access limitations, 173
STREAM clause, 166
syntax diagram of, 163
table reference within, 166
TRANSPOSE clause, 170
UNION ALL operation, 176
union operation within, 171, 175
views and, 173
WHERE clause, 169
Self-referencing INSERT, 144
SEQUENCE BY clause
examples of, 307
SELECT statement use of, 306
syntax diagram of, 306
Sequence functions
summary of, 321
DIFF1, 375
DIFF2, 377
LASTNOTNULL, 389
MOVINGAVG, 408
MOVINGCOUNT, 409
MOVINGMAX, 410
MOVINGMIN, 411
MOVINGSTDDEV, 412
MOVINGSUM, 414
MOVINGVARIANCE, 415
OFFSET, 421
RANK/RUNNINGRANK, 427
ROWS SINCE, 434
ROWS SINCE CHANGED, 436
RUNNINGAVG, 439
RUNNINGCOUNT, 440
RUNNINGMAX, 441
RUNNINGMIN, 442
RUNNINGSTDDEV, 443
RUNNINGSUM, 444
RUNNINGVARIANCE, 445
THIS, 459
Sequence-generating column, 74
Sequence-generator table
recalibrating the current value, 81
SERIALIZABLE, 29, 35
Set functions, 317
SET ON ROLLBACK clause
DELETE description of, 106
UPDATE description of, 197
SET PARAM command, 117
SET SCHEMA statement
example of, 184
scope of, 184
syntax, 184
SET TABLE TIMEOUT statement
considerations, 186
description of, 185
526 Index