1 echo Create table t1
(f1 varchar
(10), f2 char
(10), f3 varchar
(10), f4 int
);
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 echo select * from t1
;
12 ---------------------------------------------------------
13 t1.f1 t1.f2 t1.f3 t1.f4
14 ---------------------------------------------------------
24 echo select * from t1 where f1
='CSQL2';
25 ---------------------------------------------------------
26 t1.f1 t1.f2 t1.f3 t1.f4
27 ---------------------------------------------------------
33 echo select * from t1 where not
(f1
='CSQL2');
34 ---------------------------------------------------------
35 t1.f1 t1.f2 t1.f3 t1.f4
36 ---------------------------------------------------------
42 echo select * from t1 where f1
='CSQL1' and f2
='LAKS1';
43 ---------------------------------------------------------
44 t1.f1 t1.f2 t1.f3 t1.f4
45 ---------------------------------------------------------
49 echo select * from t1 where f2
='LAKS1' and not
(f1
='CSQL2');
50 ---------------------------------------------------------
51 t1.f1 t1.f2 t1.f3 t1.f4
52 ---------------------------------------------------------
56 echo select * from t1 where f1
='CSQL1' and f2
='LAKS1' and f3
='BBSR1';
57 ---------------------------------------------------------
58 t1.f1 t1.f2 t1.f3 t1.f4
59 ---------------------------------------------------------
62 echo select * from t1 where f1
='CSQL1' and f2
='LAKS1' and not
(f3
='BBSR1');
63 ---------------------------------------------------------
64 t1.f1 t1.f2 t1.f3 t1.f4
65 ---------------------------------------------------------
68 echo select * from t1 where f1
='CSQL1' and f2
='LAKS1' and not
(f4
=20);
69 ---------------------------------------------------------
70 t1.f1 t1.f2 t1.f3 t1.f4
71 ---------------------------------------------------------
74 echo select * from t1 where f1
='CSQL1' and f2
='LAKS1' or not
(f4
=20);
75 ---------------------------------------------------------
76 t1.f1 t1.f2 t1.f3 t1.f4
77 ---------------------------------------------------------
87 echo select * from t1 where f1
='CSQL1' or f2
='LAKS1' and not
(f4
=20);
88 ---------------------------------------------------------
89 t1.f1 t1.f2 t1.f3 t1.f4
90 ---------------------------------------------------------