2 Statement Executed
: Rows Affected
= 1
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 SELECT
* FROM t1
;
14 ---------------------------------------------------------
15 t1.f1 t1.f2 t1.f3 t1.f4
16 ---------------------------------------------------------
17 3 AAA
2.500000 2008/7/1
18 2 AAA
2.500000 2008/7/2
19 4 GGG
4.500000 2008/7/3
20 1 DEF
1.500000 2008/7/1
21 6 CCC
6.500000 2008/7/2
22 5 HHH
5.500000 2008/7/3
23 2 AAA
2.500000 2008/7/1
24 6 CCC
6.500000 2008/7/4
25 3 ABB
2.600000 2008/7/5
26 2 BBB
1.600000 2008/7/4
27 1 DDD
1.600000 2008/7/1
29 echo SELECT
* FROM t1 WHERE f1
<= 4 ORDER BY f1
;
30 ---------------------------------------------------------
31 t1.f1 t1.f2 t1.f3 t1.f4
32 ---------------------------------------------------------
33 1 DDD
1.600000 2008/7/1
34 1 DEF
1.500000 2008/7/1
35 2 BBB
1.600000 2008/7/4
36 2 AAA
2.500000 2008/7/1
37 2 AAA
2.500000 2008/7/2
38 3 ABB
2.600000 2008/7/5
39 3 AAA
2.500000 2008/7/1
40 4 GGG
4.500000 2008/7/3
42 echo SELECT
* FROM t1 WHERE f1
<= 4 ORDER BY f1 DESC
;
43 ---------------------------------------------------------
44 t1.f1 t1.f2 t1.f3 t1.f4
45 ---------------------------------------------------------
46 4 GGG
4.500000 2008/7/3
47 3 ABB
2.600000 2008/7/5
48 3 AAA
2.500000 2008/7/1
49 2 BBB
1.600000 2008/7/4
50 2 AAA
2.500000 2008/7/1
51 2 AAA
2.500000 2008/7/2
52 1 DDD
1.600000 2008/7/1
53 1 DEF
1.500000 2008/7/1
55 echo SELECT f1
, t1.f2
, f4 FROM t1 WHERE t1.f1
<= 4 OR t1.f3
<= 4.5 ORDER BY t1.f1
, f4
;
56 ---------------------------------------------------------
58 ---------------------------------------------------------
68 echo SELECT f1
, f2
, t1.f4 FROM t1 WHERE t1.f1
<= 4 OR t1.f3
<= 4.5 ORDER BY f1
, t1.f4 DESC
;
69 ---------------------------------------------------------
71 ---------------------------------------------------------
81 echo SELECT f1
, f2
, t1.f4 FROM t1 WHERE t1.f1
<= 4 OR t1.f3
<= 4.5 ORDER BY f1 DESC
, t1.f4 DESC
;
82 ---------------------------------------------------------
84 ---------------------------------------------------------
94 echo SELECT f1
, t1.f4
, f2 FROM t1 WHERE t1.f1
<= 4 OR t1.f3
<= 4.5 ORDER BY t1.f1
, f4
, t1.f2
;
95 ---------------------------------------------------------
97 ---------------------------------------------------------
107 echo SELECT t1.f1
, f4
, t1.f2 FROM t1 WHERE t1.f1
<= 4 OR t1.f3
<= 4.5 ORDER BY f1
, t1.f4
, f2 DESC
;
108 ---------------------------------------------------------
110 ---------------------------------------------------------
120 echo SELECT t1.f1
, f4
, t1.f2 FROM t1 WHERE t1.f1
<= 4 OR t1.f3
<= 4.5 ORDER BY f1 DESC
, t1.f4 DESC
, f2 DESC
;
121 ---------------------------------------------------------
123 ---------------------------------------------------------