3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 Statement Executed
: Rows Affected
= 1
12 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 ---------------------------------------------------------
16 ---------------------------------------------------------
23 ---------------------------------------------------------
25 ---------------------------------------------------------
33 echo select count
(f1
) from t1
;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
39 echo select count
(f2
) from t1
;
40 ---------------------------------------------------------
42 ---------------------------------------------------------
45 echo select sum(f1
) from t1
;
46 ---------------------------------------------------------
48 ---------------------------------------------------------
51 echo select sum(f3
) from t1
;
52 ---------------------------------------------------------
54 ---------------------------------------------------------
57 echo select avg
(f1
) from t1
;
58 ---------------------------------------------------------
60 ---------------------------------------------------------
63 echo select avg
(f2
) from t1
;
64 ---------------------------------------------------------
66 ---------------------------------------------------------
69 echo select min
(f2
) from t1
;
70 ---------------------------------------------------------
72 ---------------------------------------------------------
75 echo select max
(f3
) from t1
;
76 ---------------------------------------------------------
78 ---------------------------------------------------------
81 echo select avg
(t1.f2
) from t1
;
82 ---------------------------------------------------------
84 ---------------------------------------------------------
87 echo select count
(t1.f3
) from t1
;
88 ---------------------------------------------------------
90 ---------------------------------------------------------
93 echo select min
(t1.f3
) from t1
;
94 ---------------------------------------------------------
96 ---------------------------------------------------------
99 echo select avg
(t1.f2
), min
(f3
), count
(t1.f1
) from t1
;
100 ---------------------------------------------------------
101 AVG
(t1.f2
) MIN
(f3
) COUNT
(t1.f1
)
102 ---------------------------------------------------------
105 echo select avg
(t1.f2
),avg
(t2.f2
) from t1
,t2
;
106 ---------------------------------------------------------
107 AVG
(t1.f2
) AVG
(t2.f2
)
108 ---------------------------------------------------------
111 echo select avg
(t1.f2
), min
(t2.f2
), max
(t1.f2
), count
(t2.f3
), sum(t1.f1
) from t1
,t2
;
112 ---------------------------------------------------------
113 AVG
(t1.f2
) MIN
(t2.f2
) MAX
(t1.f2
) COUNT
(t2.f3
) SUM
(t1.f1
)
114 ---------------------------------------------------------