Lines Matching refs:FROM
33 COPY t1 FROM 'data1.txt'
38 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
44 lsort [execsql {SELECT DISTINCT log FROM t1}]
47 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
51 SELECT DISTINCT log FROM t1
53 SELECT n FROM t1 WHERE log=3
60 SELECT DISTINCT log FROM t1
62 SELECT n FROM t1 WHERE log=3
64 SELECT * FROM t2;
71 SELECT DISTINCT log FROM t1
73 SELECT n FROM t1 WHERE log=3
75 SELECT * FROM t2;
81 SELECT DISTINCT log FROM t1
83 SELECT n FROM t1 WHERE log=2
89 SELECT DISTINCT log FROM t1
91 SELECT n FROM t1 WHERE log=2;
92 SELECT * FROM t2;
98 SELECT log FROM t1 WHERE n IN
99 (SELECT DISTINCT log FROM t1 UNION ALL
100 SELECT n FROM t1 WHERE log=3)
106 SELECT DISTINCT log FROM t1 ORDER BY log
108 SELECT n FROM t1 WHERE log=3
118 SELECT DISTINCT log FROM t1
120 SELECT n FROM t1 WHERE log=3
126 SELECT log FROM t1 WHERE n IN
127 (SELECT DISTINCT log FROM t1 UNION
128 SELECT n FROM t1 WHERE log=3)
134 SELECT DISTINCT log FROM t1 ORDER BY log
136 SELECT n FROM t1 WHERE log=3
146 SELECT DISTINCT log FROM t1
148 SELECT n FROM t1 WHERE log=3
155 SELECT DISTINCT log FROM t1
157 SELECT n FROM t1 WHERE log=3
159 SELECT * FROM t2;
166 SELECT DISTINCT log FROM t1
168 SELECT n FROM t1 WHERE log=3
170 SELECT * FROM t2;
176 SELECT log FROM t1 WHERE n IN
177 (SELECT DISTINCT log FROM t1 EXCEPT
178 SELECT n FROM t1 WHERE log=3)
184 SELECT DISTINCT log FROM t1 ORDER BY log
186 SELECT n FROM t1 WHERE log=3
196 SELECT DISTINCT log FROM t1
198 SELECT n FROM t1 WHERE log=3
204 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
206 SELECT n FROM t1 WHERE log=3
213 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
215 SELECT n FROM t1 WHERE log=3
217 SELECT * FROM t2;
224 SELECT DISTINCT log FROM t1 UNION ALL SELECT 6
226 SELECT n FROM t1 WHERE log=3
228 SELECT * FROM t2;
234 SELECT log FROM t1 WHERE n IN
235 (SELECT DISTINCT log FROM t1 INTERSECT
236 SELECT n FROM t1 WHERE log=3)
242 SELECT DISTINCT log FROM t1 ORDER BY log
244 SELECT n FROM t1 WHERE log=3
254 SELECT DISTINCT log FROM t2
256 SELECT n FROM t1 WHERE log=3
263 SELECT DISTINCT log AS "xyzzy" FROM t1
265 SELECT n FROM t1 WHERE log=3
272 SELECT DISTINCT log AS xyzzy FROM t1
274 SELECT n FROM t1 WHERE log=3
281 SELECT DISTINCT log FROM t1
283 SELECT n FROM t1 WHERE log=3
290 SELECT DISTINCT log FROM t1
292 SELECT n FROM t1 WHERE log=3
299 SELECT DISTINCT log FROM t1
301 SELECT n FROM t1 WHERE log=3
308 SELECT DISTINCT log FROM t1
310 SELECT n FROM t1 WHERE log=3
316 SELECT DISTINCT log FROM t1
318 SELECT n FROM t1 WHERE log=3
324 SELECT DISTINCT log FROM t1
326 SELECT n FROM t1 WHERE log=3
332 SELECT DISTINCT 1, log FROM t1
334 SELECT 2, n FROM t1 WHERE log=3
340 SELECT DISTINCT 1, log FROM t1
342 SELECT 2, n FROM t1 WHERE log=3
348 SELECT DISTINCT 1, log FROM t1
350 SELECT 2, n FROM t1 WHERE log=3
356 SELECT DISTINCT log, n FROM t1
358 SELECT n FROM t1 WHERE log=3
365 SELECT log FROM t1 WHERE n=2
367 SELECT log FROM t1 WHERE n=3
369 SELECT log FROM t1 WHERE n=4
371 SELECT log FROM t1 WHERE n=5
379 SELECT log, count(*) as cnt FROM t1 GROUP BY log
381 SELECT log, n FROM t1 WHERE n=7
387 SELECT log, count(*) FROM t1 GROUP BY log
389 SELECT log, n FROM t1 WHERE n=7
416 SELECT * FROM (
423 SELECT DISTINCT * FROM (
430 SELECT DISTINCT * FROM (
450 CREATE TABLE t2 AS SELECT log AS 'x', count(*) AS 'y' FROM t1 GROUP BY log;
451 SELECT * FROM t2 ORDER BY x;
456 SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 INTERSECT SELECT x FROM t2)
462 SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 EXCEPT SELECT x FROM t2)
468 SELECT * FROM t1 WHERE n IN (SELECT n FROM t1 UNION SELECT x FROM t2)
488 SELECT DISTINCT b FROM t3 ORDER BY c;
493 SELECT DISTINCT c FROM t3 ORDER BY c;