Lines Matching full:order

44   execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
47   execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
50   execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
53   execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
56   execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
59   execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
62   execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
65   execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5}
68   execsql {SELECT * FROM t1 AS a, t1 AS b ORDER BY a.x, b.x LIMIT 5 OFFSET 32}
91     SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
92     ORDER BY z LIMIT 5;
100     INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
129     SELECT x FROM t4 ORDER BY y DESC LIMIT 1 OFFSET 999;
137         ORDER BY x LIMIT 2;
138     SELECT * FROM t5 ORDER BY x;
145         ORDER BY x DESC LIMIT 2;
146     SELECT * FROM t5 ORDER BY x;
152     INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
153     SELECT * FROM t5 ORDER BY x LIMIT 2;
158     SELECT * FROM t5 ORDER BY x DESC, y DESC LIMIT 2;
165                    ORDER BY 1, 2 LIMIT 1000;
255     SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
265     SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
275     SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 ORDER BY 1 DESC LIMIT 2;
296        ORDER BY 1 DESC LIMIT 1 OFFSET 1;