Neoview SQL Reference Manual (R2.3)

Comparison Predicates..................................................................................................................244
Considerations for Comparison Predicates..............................................................................245
Examples of Comparison Predicates........................................................................................246
EXISTS Predicate............................................................................................................................248
Examples of EXISTS.................................................................................................................248
IN Predicate...................................................................................................................................249
Considerations for IN...............................................................................................................249
Examples of IN.........................................................................................................................250
NULL Predicate.............................................................................................................................251
Considerations for NULL.........................................................................................................251
Examples of NULL...................................................................................................................252
Quantified Comparison Predicates...............................................................................................252
Considerations for ALL, ANY, SOME......................................................................................253
Examples of ALL, ANY, SOME................................................................................................253
Privileges.............................................................................................................................................255
Considerations...............................................................................................................................255
General Rules for object-privilege and schema-privilege.......................................255
Privilege Descriptions for object-privilege.....................................................................255
General Rules for column-list.............................................................................................256
Schemas...............................................................................................................................................257
Search Condition.................................................................................................................................258
Considerations for Search Condition............................................................................................258
Order of Evaluation..................................................................................................................258
Column References...................................................................................................................258
Subqueries................................................................................................................................258
Examples of Search Condition.......................................................................................................259
Subquery.............................................................................................................................................260
SELECT Form of a Subquery.........................................................................................................260
Using Subqueries to Provide Comparison Values.........................................................................260
Nested Subqueries When Providing Comparison Values.............................................................260
Correlated Subqueries When Providing Comparison Values.......................................................261
Tables...................................................................................................................................................262
Base Tables and Views........................................................................................................................262
Example of a Base Table......................................................................................................................262
Triggers................................................................................................................................................263
Views...................................................................................................................................................264
SQL Views......................................................................................................................................264
Example of a View....................................................................................................................264
MVGROUPs ..................................................................................................................................264
5 SQL Clauses...............................................................................................................267
DEFAULT Clause................................................................................................................................268
Examples of DEFAULT..................................................................................................................269
SAMPLE Clause..................................................................................................................................270
Considerations for SAMPLE..........................................................................................................271
Sample Rows............................................................................................................................271
Cluster Sampling......................................................................................................................271
Examples of SAMPLE....................................................................................................................272
SEQUENCE BY Clause.......................................................................................................................278
Considerations for SEQUENCE BY...............................................................................................278
Examples of SEQUENCE BY.........................................................................................................279
TRANSPOSE Clause...........................................................................................................................281
Considerations for TRANSPOSE...................................................................................................282
Multiple TRANSPOSE Clauses and Sets..................................................................................282
12 Table of Contents