Lines Matching refs:y
29 CREATE TABLE t1(x, y);
51 SELECT DISTINCT y FROM t1 ORDER BY y;
56 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
57 } {x 1 y 1}
59 execsql {SELECT count(*) FROM (SELECT y FROM t1)}
62 execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
65 execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
68 execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
74 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
75 (SELECT max(x),y FROM t1 GROUP BY y) as b
76 WHERE a.y=b.y ORDER BY a.y
81 SELECT a.y, a.[count(*)], [max(x)], [count(*)]
82 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
83 (SELECT max(x),y FROM t1 GROUP BY y) as b
84 WHERE a.y=b.y ORDER BY a.y
90 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
91 (SELECT max(x) as r, y as s FROM t1 GROUP BY y) as b
97 SELECT q, p, r, b.[min(x)+y]
98 FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
99 (SELECT max(x) as r, y as s, min(x)+y FROM t1 GROUP BY y) as b
164 } {x 3 y 2}
176 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
181 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
186 SELECT x,y,x+y FROM (SELECT avg(a) as 'x', avg(b) as 'y' FROM t2 WHERE a=4)
191 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
197 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1)
203 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
209 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', avg(y) as 'b' FROM t1 WHERE y=4)
215 SELECT a,b,a+b FROM (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
222 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b)
229 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
236 (SELECT avg(x) as 'a', y as 'b' FROM t1 GROUP BY b HAVING a>1)
242 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
248 SELECT [count(*)],y FROM (SELECT count(*), y FROM t1 GROUP BY y)
249 ORDER BY y
256 (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
262 SELECT y FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
267 SELECT DISTINCT y FROM (SELECT y FROM t1) WHERE y<5 ORDER BY y
272 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1) WHERE y<5 ORDER BY y
277 SELECT avg(y) FROM (SELECT DISTINCT y FROM t1 WHERE y<5) ORDER BY y
284 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3) AS 'p',
285 (SELECT x AS 'b' FROM t1 WHERE y=4) AS 'q'
293 (SELECT x+3 AS 'a', x FROM t1 WHERE y=3),
294 (SELECT x AS 'b' FROM t1 WHERE y=4)
404 SELECT y, p, q, r FROM
405 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
407 WHERE y=p
415 SELECT y, p, q, r FROM
416 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
418 WHERE y=p
424 SELECT DISTINCT y, p, q, r FROM
425 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
427 WHERE y=p
433 (SELECT y, p, q, r FROM
434 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
436 WHERE y=p) AS e,
445 (SELECT y, p, q, r FROM
446 (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
448 WHERE y=p) AS e,
505 SELECT x, y FROM (SELECT x, (SELECT 10+x) y FROM t1 LIMIT -1 OFFSET 1);
510 SELECT x, y FROM (SELECT x, (SELECT 10)+x y FROM t1 LIMIT -1 OFFSET 1);
572 CREATE TABLE t2(w INT, y VARCHAR(8));
573 INSERT INTO t2(w,y) VALUES(1,'one'),(2,'two'),(3,'three'),(4,'four');
574 CREATE INDEX t2wy ON t2(w,y);
576 SELECT cnt, xyz, (SELECT y FROM t2 WHERE w=cnt), '|'
581 SELECT cnt, xyz, lower((SELECT y FROM t2 WHERE w=cnt)), '|'
588 WHERE (SELECT y FROM t2 WHERE w=cnt)!='two'
594 ORDER BY lower((SELECT y FROM t2 WHERE w=cnt));
598 CASE WHEN (SELECT y FROM t2 WHERE w=cnt)=='two'
609 CREATE TABLE t2(y, z);
610 SELECT ( SELECT y FROM t2 WHERE z = cnt )