1 echo create table t1
(f1 int
,f2 char
(20));
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 echo create table ct1 as
select * from t1
;
15 echo create table ct2 as
select * from t1 where f1
< 6;
17 echo create table ct3 as
select f2 from t1
;
19 echo create table ct4 as
select f2 from t1 where f1
>3 and f1
<8;
21 CREATE TABLE t1
(f1 INT
, f2 CHAR
(20));
22 CREATE TABLE ct1
(f1 INT
, f2 CHAR
(20));
23 CREATE TABLE ct2
(f1 INT
, f2 CHAR
(20));
24 CREATE TABLE ct3
(f2 CHAR
(20));
25 CREATE TABLE ct4
(f2 CHAR
(20));
26 INSERT INTO t1 VALUES
(1, 'CSQL1');
27 INSERT INTO t1 VALUES
(2, 'CSQL2');
28 INSERT INTO t1 VALUES
(3, 'CSQL3');
29 INSERT INTO t1 VALUES
(4, 'CSQL4');
30 INSERT INTO t1 VALUES
(5, 'CSQL5');
31 INSERT INTO t1 VALUES
(6, 'CSQL6');
32 INSERT INTO t1 VALUES
(7, 'CSQL7');
33 INSERT INTO t1 VALUES
(8, 'CSQL8');
34 INSERT INTO t1 VALUES
(9, 'CSQL9');
35 INSERT INTO t1 VALUES
(10, 'CSQL10');
36 INSERT INTO ct1 VALUES
(1, 'CSQL1');
37 INSERT INTO ct1 VALUES
(2, 'CSQL2');
38 INSERT INTO ct1 VALUES
(3, 'CSQL3');
39 INSERT INTO ct1 VALUES
(4, 'CSQL4');
40 INSERT INTO ct1 VALUES
(5, 'CSQL5');
41 INSERT INTO ct1 VALUES
(6, 'CSQL6');
42 INSERT INTO ct1 VALUES
(7, 'CSQL7');
43 INSERT INTO ct1 VALUES
(8, 'CSQL8');
44 INSERT INTO ct1 VALUES
(9, 'CSQL9');
45 INSERT INTO ct1 VALUES
(10, 'CSQL10');
46 INSERT INTO ct2 VALUES
(1, 'CSQL1');
47 INSERT INTO ct2 VALUES
(2, 'CSQL2');
48 INSERT INTO ct2 VALUES
(3, 'CSQL3');
49 INSERT INTO ct2 VALUES
(4, 'CSQL4');
50 INSERT INTO ct2 VALUES
(5, 'CSQL5');
51 INSERT INTO ct3 VALUES
( 'CSQL1');
52 INSERT INTO ct3 VALUES
( 'CSQL2');
53 INSERT INTO ct3 VALUES
( 'CSQL3');
54 INSERT INTO ct3 VALUES
( 'CSQL4');
55 INSERT INTO ct3 VALUES
( 'CSQL5');
56 INSERT INTO ct3 VALUES
( 'CSQL6');
57 INSERT INTO ct3 VALUES
( 'CSQL7');
58 INSERT INTO ct3 VALUES
( 'CSQL8');
59 INSERT INTO ct3 VALUES
( 'CSQL9');
60 INSERT INTO ct3 VALUES
( 'CSQL10');
61 INSERT INTO ct4 VALUES
( 'CSQL4');
62 INSERT INTO ct4 VALUES
( 'CSQL5');
63 INSERT INTO ct4 VALUES
( 'CSQL6');
64 INSERT INTO ct4 VALUES
( 'CSQL7');