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