Lines Matching refs:FROM

32     COPY t1 FROM 'data1.txt';
35   execsql {SELECT count(*) FROM t1}
41   execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44   execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47   execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50   execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53   execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56   execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
63   execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
66   execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
69   execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
72   execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) OR b=512 ORDER BY a}
75   execsql {SELECT a+100*(b IN (8,16,24)) FROM t1 ORDER BY b}
79   set v [catch {execsql {SELECT a FROM t1 WHERE b IN (b+10,20)}} msg]
83   set v [catch {execsql {SELECT a FROM t1 WHERE b IN (max(5,10,b),20)}} msg]
87   execsql {SELECT a FROM t1 WHERE b IN (8*2,64/2) ORDER BY b}
90   set v [catch {execsql {SELECT a FROM t1 WHERE b IN (max(5,10),20)}} msg]
94   set v [catch {execsql {SELECT a FROM t1 WHERE min(0,b IN (a,30))}} msg]
98   set v [catch {execsql {SELECT a FROM t1 WHERE c IN (10,20)}} msg]
106     SELECT a FROM t1
107     WHERE b IN (SELECT b FROM t1 WHERE a<5)
113     SELECT a FROM t1
114     WHERE b IN (SELECT b FROM t1 WHERE a<5) OR b==512
120     SELECT a + 100*(b IN (SELECT b FROM t1 WHERE a<5)) FROM t1 ORDER BY b
129     WHERE b IN (SELECT b FROM t1 WHERE a>8)
131   execsql {SELECT b FROM t1 ORDER BY b}
135     DELETE FROM t1 WHERE b IN (SELECT b FROM t1 WHERE a>8)
137   execsql {SELECT a FROM t1 ORDER BY a}
141     DELETE FROM t1 WHERE b NOT IN (SELECT b FROM t1 WHERE a>4)
143   execsql {SELECT a FROM t1 ORDER BY a}
153     SELECT * FROM t1
175     SELECT * FROM ta WHERE a<10;
189     SELECT * FROM tb WHERE a<10;
194     SELECT a FROM ta WHERE b IN (SELECT a FROM tb);
199     SELECT a FROM ta WHERE b NOT IN (SELECT a FROM tb);
204     SELECT a FROM ta WHERE b IN (SELECT b FROM tb);
209     SELECT a FROM ta WHERE b NOT IN (SELECT b FROM tb);
214     SELECT a FROM ta WHERE a IN (SELECT a FROM tb);
219     SELECT a FROM ta WHERE a NOT IN (SELECT a FROM tb);
224     SELECT a FROM ta WHERE a IN (SELECT b FROM tb);
229     SELECT a FROM ta WHERE a NOT IN (SELECT b FROM tb);
237     SELECT a FROM t1 WHERE a IN ();
242     SELECT a FROM t1 WHERE a IN (5);
247     SELECT a FROM t1 WHERE a NOT IN () ORDER BY a;
252     SELECT a FROM t1 WHERE a IN (5) AND b IN ();
257     SELECT a FROM t1 WHERE a IN (5) AND b NOT IN ();
262     SELECT a FROM ta WHERE a IN ();
267     SELECT a FROM ta WHERE a NOT IN ();
273     SELECT b FROM t1 WHERE a IN ('hello','there')
278     SELECT b FROM t1 WHERE a IN ("hello",'there')
286     CREATE TABLE t4 AS SELECT a FROM tb;
287     SELECT * FROM t4;    
292     SELECT b FROM t1 WHERE a IN t4;
297     SELECT b FROM t1 WHERE a NOT IN t4;
302     SELECT b FROM t1 WHERE a NOT IN tb;