OLAP 関数の BNF 文法
文法規則 22
文法規則 23
文法規則 24 文法規則 25
文法規則 26
文法規則 27 文法規則 28
文法規則 29
文法規則 30 文法規則 31 文法規則 32
文法規則 33 文法規則 34
文法規則 35
文法規則 36
文法規則 37
文法規則 38 文法規則 39
<WINDOW DEFINITION LIST> ::=
<WINDOW DEFINITION> [ { <COMMA> <WINDOW DEFINITION> } . . . ]
<WINDOW DEFINITION> ::=
<NEW WINDOW NAME> AS <WINDOW SPECIFICATION> <NEW WINDOW NAME> ::= <WINDOW NAME>
<WINDOW SPECIFICATION> ::=
<LEFT PAREN> <WINDOW SPECIFICATION> <DETAILS> <RIGHT PAREN>
<WINDOW SPECIFICATION DETAILS> ::= [ <EXISTING WINDOW NAME> ]
[ <WINDOW PARTITION CLAUSE> ] [ <WINDOW ORDER CLAUSE> ]
[ <WINDOW FRAME CLAUSE> ]
<EXISTING WINDOW NAME> ::= <WINDOW NAME>
<WINDOW PARTITION CLAUSE> ::=
PARTITION BY <WINDOW PARTITION EXPRESSION LIST>
<WINDOW PARTITION EXPRESSION LIST> ::= <WINDOW PARTITION EXPRESSION>
[ { <COMMA> <WINDOW PARTITION EXPRESSION> } . . . ]
<WINDOW PARTITION EXPRESSION> ::= <EXPRESSION>
<WINDOW ORDER CLAUSE> ::= <ORDER SPECIFICATION>
<WINDOW FRAME CLAUSE> ::=
<WINDOW FRAME UNIT> <WINDOW FRAME EXTENT>
<WINDOW FRAME UNIT> ::= ROWS RANGE
<WINDOW FRAME EXTENT> ::= <WINDOW FRAME START> <WINDOW FRAME BETWEEN>
<WINDOW FRAME START> ::=
UNBOUNDED PRECEDING
<WINDOW FRAME PRECEDING> CURRENT ROW
<WINDOW FRAME PRECEDING> ::= <UNSIGNED VALUE SPECIFICATION>
PRECEDING
<WINDOW FRAME BETWEEN> ::=
BETWEEN <WINDOW FRAME BOUND 1> AND <WINDOW FRAME BOUND 2>
<WINDOW FRAME BOUND 1> ::= <WINDOW FRAME BOUND>
<WINDOW FRAME BOUND 2> ::= <WINDOW FRAME BOUND>
100 | Sybase IQ |
