Neoview SQL Reference Manual (R2.2)

5 SQL Clauses
Clauses are used by Neoview SQL statements to specify default values, ways to sample or sort
data, how to store physical data, and other details.
This section describes:
• “DEFAULT Clause”. Specifies a default value for a column being created.
• “SAMPLE Clause”. Specifies the sampling method used to select a subset of the intermediate
result table of a SELECT statement.
• “SEQUENCE BY Clause”. Specifies the order in which to sort rows of the intermediate result
table for calculating sequence functions.
• “TRANSPOSE Clause” (page 271). Generates, for each row of the SELECT source table, a
row for each item in the transpose item list.
257