Lines Matching refs:FROM
33 COPY t1 FROM 'data1.txt'
38 execsql {SELECT count(*) FROM t1}
41 execsql {SELECT count(*) FROM t1 LIMIT 5}
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}
73 CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 2;
74 SELECT count(*) FROM (SELECT * FROM v1);
79 CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 2;
80 SELECT count(*) FROM t2;
85 SELECT count(*) FROM t1 WHERE rowid IN (SELECT rowid FROM t1 LIMIT 2);
91 SELECT z FROM (SELECT y*10+x AS z FROM t1 ORDER BY x LIMIT 10)
100 INSERT INTO t3 SELECT x FROM t1 ORDER BY x LIMIT 10 OFFSET 1;
101 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
102 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
103 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
104 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
105 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
106 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
107 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
108 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
109 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
110 INSERT INTO t3 SELECT x+(SELECT max(x) FROM t3) FROM t3;
112 SELECT count(*) FROM t3;
117 SELECT x FROM t3 LIMIT 2 OFFSET 10000
128 FROM t3 LIMIT 1000;
129 SELECT x FROM t4 ORDER BY y DESC LIMIT 1 OFFSET 999;
136 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
138 SELECT * FROM t5 ORDER BY x;
143 DELETE FROM t5;
144 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
146 SELECT * FROM t5 ORDER BY x;
151 DELETE FROM t5;
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;
163 DELETE FROM t5;
164 INSERT INTO t5 SELECT a.x*100+b.x, a.y*100+b.y FROM t1 AS a, t1 AS b
166 SELECT count(*), sum(x), sum(y), min(x), max(x), min(y), max(y) FROM t5;
179 INSERT INTO t6 SELECT a+2 FROM t6;
181 SELECT * FROM t6;
186 SELECT * FROM t6 LIMIT -1 OFFSET -1;
191 SELECT * FROM t6 LIMIT 2 OFFSET -123;
196 SELECT * FROM t6 LIMIT -432 OFFSET 2;
201 SELECT * FROM t6 LIMIT -1
206 SELECT * FROM t6 LIMIT -1 OFFSET 1
211 SELECT * FROM t6 LIMIT 0
216 SELECT * FROM t6 LIMIT 0 OFFSET 1
225 SELECT x FROM t2 LIMIT 5 UNION ALL SELECT a FROM t6;
230 SELECT x FROM t2 LIMIT 5 UNION SELECT a FROM t6;
235 SELECT x FROM t2 LIMIT 5 EXCEPT SELECT a FROM t6 LIMIT 3;
240 SELECT x FROM t2 LIMIT 0,5 INTERSECT SELECT a FROM t6;
245 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 5;
250 SELECT x FROM t2 UNION ALL SELECT a FROM t6 LIMIT 3 OFFSET 1;
255 SELECT x FROM t2 UNION ALL SELECT a FROM t6 ORDER BY 1 LIMIT 3 OFFSET 1;
260 SELECT x FROM t2 UNION SELECT x+2 FROM t2 LIMIT 2 OFFSET 1;
265 SELECT x FROM t2 UNION SELECT x+2 FROM t2 ORDER BY 1 DESC LIMIT 2 OFFSET 1;
270 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 LIMIT 2;
275 SELECT a+9 FROM t6 EXCEPT SELECT y FROM t2 ORDER BY 1 DESC LIMIT 2;
280 SELECT a+26 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
285 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1;
290 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2 LIMIT 1 OFFSET 1;
295 SELECT a+27 FROM t6 INTERSECT SELECT x FROM t2
305 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5;
310 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 5;
315 SELECT DISTINCT round(x/100) FROM t3 LIMIT 5 OFFSET 25;