Filter
Top Products
第 4 章 OLAP の使用
パフォーマンス＆チューニング・ガイド 99
文法規則 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> ::=
SUM | MAX | MIN | AVG | COUNT
文法規則 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>