2 echo select count
(f1
) from t1
;
3 ---------------------------------------------------------
5 ---------------------------------------------------------
8 echo select count
(*) from t1 where f4
='AAA';
9 ---------------------------------------------------------
11 ---------------------------------------------------------
14 echo select sum(f1
) from t1
;
15 ---------------------------------------------------------
17 ---------------------------------------------------------
20 echo select avg
(f1
) from t1
;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
26 echo select min
(t1.f1
) from t1
;
27 ---------------------------------------------------------
29 ---------------------------------------------------------
32 echo select min
(f4
) from t1
;
33 ---------------------------------------------------------
35 ---------------------------------------------------------
38 echo select max
(t1.f1
) from t1
;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
44 echo select max
(f4
) from t1
;
45 ---------------------------------------------------------
47 ---------------------------------------------------------