2 Statement Executed
: Rows Affected
= 1
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
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 echo select count
(f1
) from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
16 echo select min
(f1
) from t1
;
17 ---------------------------------------------------------
19 ---------------------------------------------------------
22 echo select max
(f3
) from t1
;
23 ---------------------------------------------------------
25 ---------------------------------------------------------
28 echo select avg
(f1
) from t1
;
29 ---------------------------------------------------------
31 ---------------------------------------------------------
34 echo select sum(f1
) from t1
;
35 ---------------------------------------------------------
37 ---------------------------------------------------------
40 echo select count
(f1
) from t1 group by f2
;
41 ---------------------------------------------------------
43 ---------------------------------------------------------
49 echo select min
(f1
) from t1 group by f2
;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
58 echo select max
(f1
) from t1 group by f2
;
59 ---------------------------------------------------------
61 ---------------------------------------------------------
67 echo select avg
(f1
) from t1 group by f2
;
68 ---------------------------------------------------------
70 ---------------------------------------------------------
76 echo select sum(f1
) from t1 group by f2
;
77 ---------------------------------------------------------
79 ---------------------------------------------------------
85 echo select min
(f1
), max
(f3
), sum(f1
) from t1
;
86 ---------------------------------------------------------
87 MIN
(f1
) MAX
(f3
) SUM
(f1
)
88 ---------------------------------------------------------
91 echo select min
(f1
), f2
, max
(f3
) from t1
;
92 Statement prepare failed with error
-28
93 echo select min
(f1
), f2
, max
(f3
) from t1 group by f2
;
94 ---------------------------------------------------------
96 ---------------------------------------------------------
102 echo select min
(f2
) from t1 group by f2
;
103 ---------------------------------------------------------
105 ---------------------------------------------------------
111 echo select count
(*) from t1
;
112 ---------------------------------------------------------
114 ---------------------------------------------------------
117 echo select count
(*) from t1 group by f2
;
118 ---------------------------------------------------------
120 ---------------------------------------------------------