1 echo CREATE TABLE t1
(f1 int
, f2 char
(10), f3
date, f4 BIGINT
);
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 Statement Executed
: Rows Affected
= 1
11 Statement Executed
: Rows Affected
= 1
12 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 Statement Executed
: Rows Affected
= 1
15 Statement Executed
: Rows Affected
= 1
16 Statement Executed
: Rows Affected
= 1
17 Statement Executed
: Rows Affected
= 1
18 echo SELECT
* FROM t1
;
19 ---------------------------------------------------------
20 t1.f1 t1.f2 t1.f3 t1.f4
21 ---------------------------------------------------------
38 echo SELECT f1
,MAX
(f3
) FROM t1 GROUP BY f1
;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
48 echo SELECT f1
,COUNT
(f3
) FROM t1 GROUP BY f1 LIMIT
3;
49 ---------------------------------------------------------
51 ---------------------------------------------------------
56 echo SELECT f1
,MIN
(f3
) FROM t1 GROUP BY f1 LIMIT
3 OFFSET
2;
57 ---------------------------------------------------------
59 ---------------------------------------------------------
64 echo SELECT f1
,SUM
(f4
) FROM t1 GROUP BY f1 LIMIT
3 OFFSET
2;
65 ---------------------------------------------------------
67 ---------------------------------------------------------