Sybase IQ 12.7 User Manual

OLAP 関数の BNF 文法 

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>