Lines Matching full:where

53   execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
73     WHERE a.y=b.y ORDER BY a.y
81     WHERE a.y=b.y ORDER BY a.y
89     WHERE q=s ORDER BY s
97     WHERE q=s ORDER BY s
109   execsql2 {SELECT * FROM (SELECT a, b FROM t2 WHERE a<2)}
129     WHERE a.b=b.b ORDER BY a.b
137     WHERE a.b=b.b ORDER BY a.b
145     WHERE q=s ORDER BY s
153     WHERE a.q=b.s ORDER BY a.q
159     SELECT * FROM (SELECT * FROM (SELECT * FROM t1 WHERE x=3));
168        WHERE a.q=b.s ORDER BY a.q)
179     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
184     SELECT x,y,x+y FROM (SELECT avg(a) as 'x', avg(b) as 'y' FROM t2 WHERE a=4)
190     WHERE a>10
196     WHERE a<10
201     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
202     WHERE a>10
207     SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
208     WHERE a<10
221     WHERE b<4 ORDER BY a
228     WHERE b<4 ORDER BY a
254       (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
255     WHERE a<10 ORDER BY a;
260     SELECT y FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
265     SELECT DISTINCT y FROM (SELECT y FROM t1) WHERE y<5 ORDER BY y
270     SELECT avg(y) FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
275     SELECT avg(y) FROM (SELECT DISTINCT y FROM t1 WHERE y<5) ORDER BY y
282       (SELECT x+3 AS 'a', x FROM t1 WHERE y=3) AS 'p',
283       (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q'
284     WHERE a=b
291       (SELECT x+3 AS 'a', x FROM t1 WHERE y=3),
292       (SELECT x AS 'b' FROM t1 WHERE y=4)
293     WHERE a=b
302     DELETE FROM t1 WHERE x>4;
356     SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 0)
361     SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 1)
393        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
395     WHERE  y=p
401        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
403     WHERE  y=p
409        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
411     WHERE  y=p
418          (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
420       WHERE  y=p) AS e,
421       (SELECT r AS z FROM t4 WHERE q=11) AS f
422     WHERE e.r=f.z
429          (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
431       WHERE  y=p) AS e,
432       (SELECT r AS z FROM t4 WHERE q=11) AS f
433     WHERE e.r=f.z