SUMMARIZE :
SUMMARIZE <. .> BY (< >) ADD <.> AS
< >,
<. .> - , ,
< > - A1, A2,..., AN,
< . > - , EXTEND,
< > .
< >.
SUMMARIZE R , , . R ( R1) A1, A2,..., AN, (N + 1)- . , , ( ), , : R1 ( ) . (N + 1)-o R .
, , . :
( ) :
Avg ;
Count ;
Max ;
Min ;
Sum .
, .
14.
. : .
:
SUMMARIZE BY () ADD COUNT(_) AS _
QBE. :
_14
_: _ | ||
Count | ||
ü | ü | |
:
:
Ø ,
Ø
|
|
\ \ \
Ø - \
. , . , , .
. , . , , .
- , . , .
SQL: