Neoview SQL Reference Manual (R2.3)

examples of, 272
SELECT statement use of, 270
syntax diagram of, 270
Sampling, clusters, 271
Scale, 228
Schemas, description of, 257
Search condition
Boolean operators within, 258
CASE expression use of, 306
DELETE statement use of, 92
description of, 260
examples of, 259
predicate within, 258
syntax diagram of, 258
UPDATE statement use of, 181
SECOND function
examples of, 414
syntax diagram of, 414
SELECT statement
access options, 153
authorization requirements, 154
DISTINCT clause , 147
embedded delete, 148
embedded insert, 149
embedded update, 149
FROM clause , 148
GROUP BY clause , 152, 156
HAVING clause, 153
joined table within, 150
lock modes, 153
ORDER BY clause , 154, 157
RETURN list, 148
select list elements, 147
SEQUENCE BY clause, 152
simple table within, 150
SKIP CONFLICT access, 153
stream access limitations, 155
STREAM clause, 148
syntax diagram of, 145
table reference within, 148
TRANSPOSE clause, 151
union operation within, 153, 157
views and, 154
WHERE clause, 151
self-referencing INSERT, 126
SEQUENCE BY clause
examples of, 279
SELECT statement use of, 278
syntax diagram of, 278
Sequence functions
summary of, 293
DIFF1, 345
DIFF2, 347
LASTNOTNULL, 358
MOVINGAVG, 378
MOVINGCOUNT, 379
MOVINGMAX, 381
MOVINGMIN, 382
MOVINGSTDDEV, 383
MOVINGSUM, 385
MOVINGVARIANCE, 386
OFFSET, 392
ROWS SINCE, 403
ROWS SINCE CHANGED, 405
RUNNINGAVG, 406
RUNNINGCOUNT, 407
RUNNINGMAX, 408
RUNNINGMIN, 408
RUNNINGSTDDEV, 400, 411
RUNNINGSUM, 412
RUNNINGVARIANCE, 413
THIS, 427
SERIALIZABLE, 31, 37
Set functions, 289
SET ON ROLLBACK clause
DELETE description of, 92
UPDATE description of, 180
SET PARAM command, 103
SET SCHEMA
example of, 166
SET SCHEMA statement
scope of, 166
SET SERVICE statement
syntax of, 167
SET TABLE TIMEOUT statement
syntax diagram of, 168
SET TRANSACTION statement
syntax diagram of, 170
transaction modes set by, 171
SHARE lock mode, 31
SHOWDDL statement, 175
considerations for, 175
differences between output and original DDL, 175
examples of, 176
privileges option, 176
syntax diagram of, 175
SIGN function
examples of, 415
syntax diagram of, 415
Simple table, in SELECT statement, 150
SIN function
examples of, 416
syntax diagram of, 416
SINH function
examples of, 417
syntax diagram of, 417
SKIP CONFLICT
publish/subscribe, 31
SELECT statement, 153
SMALLINT data type, 216
SPACE function
examples of, 418
syntax diagram of, 418
SQL statements
ANSI compliant, 37
Neoview SQL extensions, 38
SQL value expression, 218
SQRT function
481