第 4 章 OLAP の使用
文法規則 40
文法規則 41
文法規則 42 文法規則 43
文法規則 44
文法規則 45
文法規則 46 文法規則 47 文法規則 48
文法規則 49
文法規則 50 文法規則 51
文法規則 52
文法規則 53
<WINDOW FRAME BOUND> ::=
<WINDOW FRAME START>
UNBOUNDED FOLLOWING
<WINDOW FRAME FOLLOWING>
<WINDOW FRAME FOLLOWING> ::= <UNSIGNED VALUE SPECIFICATION>
FOLLOWING
<GROUP BY EXPRESSION> ::= <EXPRESSION>
<SIMPLE GROUP BY TERM> ::=
<GROUP BY EXPRESSION>
<LEFT PAREN> <GROUP BY EXPRESSION> <RIGHT PAREN> <LEFT PAREN> <RIGHT PAREN>
<SIMPLE GROUP BY TERM LIST> ::=
<SIMPLE GROUP BY TERM> [ { <COMMA> <SIMPLE GROUP BY TERM> } . . . ]
<COMPOSITE GROUP BY TERM> ::=
<LEFT PAREN> <SIMPLE GROUP BY TERM>
[ { <COMMA> <SIMPLE GROUP BY TERM> } . . . ]
<RIGHT PAREN>
<ROLLUP TERM> ::= ROLLUP <COMPOSITE GROUP BY TERM>
<CUBE TERM> ::= CUBE <COMPOSITE GROUP BY TERM>
<GROUP BY TERM> ::=
<SIMPLE GROUP BY TERM>
<COMPOSITE GROUP BY TERM> <ROLLUP TERM>
<CUBE TERM>
<GROUP BY TERM LIST> ::=
<GROUP BY TERM> [ { <COMMA> <GROUP BY TERM> } . . . ]
<GROUP BY CLAUSE> ::= GROUP BY <GROUPING SPECIFICATION>
<GROUPING SPECIFICATION> ::=
<GROUP BY TERM LIST>
<SIMPLE GROUP BY TERM LIST> WITH ROLLUP <SIMPLE GROUP BY TERM LIST> WITH CUBE <GROUPING SETS SPECIFICATION>
<GROUPING SETS SPECIFICATION> ::=
GROUPING SETS <LEFT PAREN> <GROUP BY TERM LIST> <RIGHT PAREN>
<ORDER SPECIFICATION> ::= ORDER BY <SORT SPECIFICATION LIST>
パフォーマンス＆チューニング・ガイド | 101 |
