Neoview SQL Reference Manual (R2.2)

Considerations for Search Condition............................................................................................248
Order of Evaluation..................................................................................................................248
Column References...................................................................................................................248
Subqueries................................................................................................................................248
Examples of Search Condition.......................................................................................................249
Subquery.............................................................................................................................................250
SELECT Form of a Subquery.........................................................................................................250
Using Subqueries to Provide Comparison Values.........................................................................250
Nested Subqueries When Providing Comparison Values.............................................................250
Correlated Subqueries When Providing Comparison Values.......................................................251
Tables...................................................................................................................................................252
Base Tables and Views........................................................................................................................252
Example of a Base Table......................................................................................................................252
Triggers................................................................................................................................................253
Views...................................................................................................................................................254
SQL Views......................................................................................................................................254
Example of a View....................................................................................................................254
MVGROUPs ..................................................................................................................................254
5 SQL Clauses...............................................................................................................257
DEFAULT Clause................................................................................................................................258
Examples of DEFAULT..................................................................................................................259
SAMPLE Clause..................................................................................................................................260
Considerations for SAMPLE..........................................................................................................261
Sample Rows............................................................................................................................261
Cluster Sampling......................................................................................................................261
Examples of SAMPLE....................................................................................................................262
SEQUENCE BY Clause.......................................................................................................................268
Considerations for SEQUENCE BY...............................................................................................268
Examples of SEQUENCE BY.........................................................................................................269
TRANSPOSE Clause...........................................................................................................................271
Considerations for TRANSPOSE...................................................................................................272
Multiple TRANSPOSE Clauses and Sets..................................................................................272
Degree and Column Order of the TRANSPOSE Result...........................................................272
Data Type of the TRANSPOSE Result......................................................................................272
Cardinality of the TRANSPOSE Result....................................................................................273
Examples of TRANSPOSE.............................................................................................................273
6 SQL Functions and Expressions................................................................................279
Categories............................................................................................................................................279
Standard Normalization................................................................................................................279
Aggregate (Set) Functions..............................................................................................................279
Character String Functions............................................................................................................280
Datetime Functions........................................................................................................................281
Mathematical Functions................................................................................................................282
Sequence Functions.......................................................................................................................283
Other Functions and Expressions..................................................................................................285
ABS Function.......................................................................................................................................286
Example of ABS.............................................................................................................................286
ACOS Function...................................................................................................................................287
Examples of ACOS........................................................................................................................287
ADD_MONTHS Function...................................................................................................................288
Examples of ADD_MONTHS........................................................................................................288
12 Table of Contents