Sybase IQ 12.7 User Manual

第

 4 章    OLAP の使用

パフォーマンス＆チューニング・ガイド

文法規則

 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>