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