Sybase IQ 12.7 User Manual

第

 4 章    OLAP の使用

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

文法規則

 8

<WINDOW AGGREGATE FUNCTION> ::=

<SIMPLE WINDOW AGGREGATE FUNCTION>
| <STATISTICAL AGGREGATE FUNCTION>

文法規則

 9

<AGGREGATE FUNCTION> ::=

<DISTINCT AGGREGATE FUNCTION>
| <SIMPLE AGGREGATE FUNCTION>
| <STATISTICAL AGGREGATE FUNCTION>

文法規則

 10

<DISTINCT AGGREGATE FUNCTION> ::=

<BASIC AGGREGATE FUNCTION TYPE> <LEFT PAREN>
<DISTINCT> <EXPRESSION> <RIGHT PAREN>
| LIST <LEFT PAREN> DISTINCT <EXPRESSION> 
[ <COMMA> <DELIMITER> ]
[ <ORDER SPECIFICATION> ] <RIGHT PAREN>

文法規則

 11

<BASIC AGGREGATE FUNCTION TYPE> ::=

文法規則

 12

<SIMPLE AGGREGATE FUNCTION> ::=

<SIMPLE AGGREGATE FUNCTION TYPE> <LEFT PAREN>
<EXPRESSION> <RIGHT PAREN>
| LIST <LEFT PAREN> <EXPRESSION> [ <COMMA>
<DELIMITER> ]
[ <ORDER SPECIFICATION> ] <RIGHT PAREN>

文法規則

 13

<SIMPLE AGGREGATE FUNCTION TYPE> ::= <SIMPLE WINDOW AGGREGATE 
FUNCTION TYPE>

文法規則

 14

<SIMPLE WINDOW AGGREGATE FUNCTION> ::=

<SIMPLE WINDOW AGGREGATE FUNCTION TYPE> <LEFT PAREN>
<EXPRESSION> <RIGHT PAREN>

| GROUPING FUNCTION

文法規則

 15

<SIMPLE WINDOW AGGREGATE FUNCTION TYPE> ::=

<BASIC AGGREGATE FUNCTION TYPE>
| STDDEV | STDDEV_POP | STDDEV_SAMP
| VARIANCE | VARIANCE_POP | VARIANCE_SAMP

文法規則

 16

<STATISTICAL AGGREGATE FUNCTION> ::=

<STATISTICAL AGGREGATE FUNCTION TYPE> <LEFT PAREN>
<DEPENDENT EXPRESSION> <COMMA> <INDEPENDENT
EXPRESSION> <RIGHT PAREN>

文法規則

 17

<STATISTICAL AGGREGATE FUNCTION TYPE> ::=

CORR | COVAR_POP | COVAR_SAMP | REGR_R2 |
REGR_INTERCEPT | REGR_COUNT | REGR_SLOPE | 
REGR_SXX | REGR_SXY | REGR_SYY | REGR_AVGY |
REGR_AVGX

文法規則

 18

<WINDOW NAME OR SPECIFICATION> ::=

<WINDOW NAME> | <IN-LINE WINDOW SPECIFICATION>

文法規則

 19

<WINDOW NAME> ::= <IDENTIFIER>

文法規則

 20

<IN-LINE WINDOW SPECIFICATION> ::= <WINDOW SPECIFICATION>

文法規則

 21

<WINDOW CLAUSE> ::= <WINDOW WINDOW DEFINITION LIST>