Lines Matching refs:t1
24 CREATE TABLE t1(x, y);
25 INSERT INTO t1 VALUES(1,1);
26 INSERT INTO t1 VALUES(2,2);
27 INSERT INTO t1 VALUES(3,2);
28 INSERT INTO t1 VALUES(4,3);
29 INSERT INTO t1 VALUES(5,3);
30 INSERT INTO t1 VALUES(6,3);
31 INSERT INTO t1 VALUES(7,3);
32 INSERT INTO t1 VALUES(8,4);
33 INSERT INTO t1 VALUES(9,4);
34 INSERT INTO t1 VALUES(10,4);
35 INSERT INTO t1 VALUES(11,4);
36 INSERT INTO t1 VALUES(12,4);
37 INSERT INTO t1 VALUES(13,4);
38 INSERT INTO t1 VALUES(14,4);
39 INSERT INTO t1 VALUES(15,4);
40 INSERT INTO t1 VALUES(16,5);
41 INSERT INTO t1 VALUES(17,5);
42 INSERT INTO t1 VALUES(18,5);
43 INSERT INTO t1 VALUES(19,5);
44 INSERT INTO t1 VALUES(20,5);
46 SELECT DISTINCT y FROM t1 ORDER BY y;
51 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
54 execsql {SELECT count(*) FROM (SELECT y FROM t1)}
57 execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
60 execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
63 execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
69 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
70 (SELECT max(x),y FROM t1 GROUP BY y) as b
77 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
78 (SELECT max(x),y FROM t1 GROUP BY y) as b
85 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
86 (SELECT max(x) as r, y as s FROM t1 GROUP BY y) as b
93 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
94 (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
102 INSERT INTO t2 SELECT * FROM t1;
157 SELECT * FROM (SELECT * FROM (SELECT * FROM t1 WHERE x=3));
172 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
177 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
187 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
193 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
199 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
205 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
211 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
218 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
225 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
232 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
238 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
244 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
252 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
258 SELECT y FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
263 SELECT DISTINCT y FROM (SELECT y FROM t1) WHERE y<5 ORDER BY y
268 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
273 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1 WHERE y<5) ORDER BY y
280 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3) AS 'p',
281 (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q'
289 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3),
290 (SELECT x AS 'b' FROM t1 WHERE y=4)
300 DELETE FROM t1 WHERE x>4;
301 SELECT * FROM t1
307 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+10 AS 'a' FROM t1
314 SELECT x AS 'a' FROM t1 UNION ALL SELECT x+1 AS 'a' FROM t1
321 SELECT x AS 'a' FROM t1 UNION SELECT x+1 AS 'a' FROM t1
328 SELECT x AS 'a' FROM t1 INTERSECT SELECT x+1 AS 'a' FROM t1
335 SELECT x AS 'a' FROM t1 EXCEPT SELECT x*2 AS 'a' FROM t1
391 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
399 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
407 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
416 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
427 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,