Lines Matching refs:FROM

32   execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
38   set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
45   execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
48   execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
51   execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
54   execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
61   execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
76     WHERE x = (SELECT sum(b) FROM t1 where a notnull) - (SELECT sum(a) FROM t1)
84   execsql {DELETE FROM t2 WHERE x < 0.5*(SELECT max(x) FROM t2)}
85   execsql {SELECT x FROM t2 ORDER BY x}
92     SELECT (SELECT a FROM t1 ORDER BY a), (SELECT a FROM t1 ORDER BY a DESC)
97     SELECT 1 IN (SELECT a FROM t1 ORDER BY a);
102     SELECT 2 IN (SELECT a FROM t1 ORDER BY a DESC);
111     INSERT INTO t3 SELECT a FROM t1 UNION ALL SELECT b FROM t1;
112     SELECT * FROM t3 ORDER BY x;
117     SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x LIMIT 2);
122     SELECT sum(x) FROM (SELECT x FROM t3 ORDER BY x DESC LIMIT 2);
127     SELECT (SELECT x FROM t3 ORDER BY x);
132     SELECT (SELECT x FROM t3 ORDER BY x DESC);
137     SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1);
142     SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1);
147     SELECT (SELECT x FROM t3 ORDER BY x LIMIT 1 OFFSET 2);
152     SELECT (SELECT x FROM t3 ORDER BY x DESC LIMIT 1 OFFSET 2);