1 drop table if exists t1, t2;
5 INSERT INTO t1 VALUES (1);
6 INSERT INTO t1 VALUES (2);
7 INSERT INTO t1 VALUES (3);
8 INSERT INTO t1 VALUES (4);
9 INSERT INTO t1 VALUES (5);
10 INSERT INTO t1 VALUES (6);
11 select MAX(a) from t1;
14 select MAX(a) from t1;
17 select MAX(a) from t1;
20 select MAX(a) from t1;
23 select MIN(a) from t1;
26 select MIN(a) from t1;
29 select MIN(a) from t1;
32 select * from t1 order by a;
40 select MIN(a) from t1;
43 select MAX(a) from t1;
46 select MAX(a) from t1;
49 select * from t1 order by a;
65 INSERT INTO t2 VALUES (1, 5, 1);
66 INSERT INTO t2 VALUES (2, 2, 7);
67 INSERT INTO t2 VALUES (3, 3, 3);
68 INSERT INTO t2 VALUES (4, 4, 4);
69 INSERT INTO t2 VALUES (5, 5, 5);
70 INSERT INTO t2 VALUES (6, 6, 6);
71 INSERT INTO t2 VALUES (7, 2, 10);
72 INSERT INTO t2 VALUES (8, 10, 2);
73 select MAX(a) from t2;
76 select MAX(b) from t2;
79 select MAX(c) from t2;
82 select MIN(a) from t2;
85 select MIN(b) from t2;
88 select MIN(c) from t2;
91 select * from t2 order by a;
101 select MIN(b) from t2;
104 select MAX(a) from t2;
107 select MAX(c) from t2;
110 select * from t2 order by a;