1 echo CREATE TABLE t1
(f1 int
, f2 char
(10), f3
date);
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 ---------------------------------------------------------
21 ---------------------------------------------------------
38 echo SELECT
* FROM t1 ORDER BY f1
;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
58 echo SELECT
* FROM t1 ORDER BY f1 LIMIT
5;
59 ---------------------------------------------------------
61 ---------------------------------------------------------
68 echo SELECT
* FROM t1 ORDER BY f1 LIMIT
5 OFFSET
5;
69 ---------------------------------------------------------
71 ---------------------------------------------------------
78 echo SELECT
* FROM t1 ORDER BY f1 DESC
;
79 ---------------------------------------------------------
81 ---------------------------------------------------------
98 echo SELECT
* FROM t1 ORDER BY f1 DESC LIMIT
5;
99 ---------------------------------------------------------
101 ---------------------------------------------------------
108 echo SELECT
* FROM t1 ORDER BY f1 DESC LIMIT
5 OFFSET
5;
109 ---------------------------------------------------------
111 ---------------------------------------------------------
118 echo SELECT
* FROM t1 ORDER BY f1 ASC
, f2 DESC
;
119 ---------------------------------------------------------
121 ---------------------------------------------------------
138 echo SELECT
* FROM t1 ORDER BY f1 ASC
, f2 DESC LIMIT
5;
139 ---------------------------------------------------------
141 ---------------------------------------------------------
148 echo SELECT
* FROM t1 ORDER BY f1 DESC
, f2 ASC LIMIT
5 OFFSET
5;
149 ---------------------------------------------------------
151 ---------------------------------------------------------