Lines Matching refs:AS

74     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
82     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
90     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
98     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
130     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
138     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
146     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
154     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
169        FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
256       (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
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)
312         SELECT x AS 'a' FROM t1 UNION ALL SELECT x+10 AS 'a' FROM t1
319         SELECT x AS 'a' FROM t1 UNION ALL SELECT x+1 AS 'a' FROM t1
326         SELECT x AS 'a' FROM t1 UNION SELECT x+1 AS 'a' FROM t1
333         SELECT x AS 'a' FROM t1 INTERSECT SELECT x+1 AS 'a' FROM t1
340         SELECT x AS 'a' FROM t1 EXCEPT SELECT x*2 AS 'a' FROM t1
355     SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c')
360     SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 0)
365     SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c' WHERE 1)
405        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
406        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
416        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
417        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
425        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
426        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
434          (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
435          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
436       WHERE  y=p) AS e,
437       (SELECT r AS z FROM t4 WHERE q=11) AS f
446          (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
447          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
448       WHERE  y=p) AS e,
449       (SELECT r AS z FROM t4 WHERE q=11) AS f
459     SELECT a.x, b.x FROM t1 AS a, (SELECT x FROM t1 LIMIT 2) AS b
577     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
582     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
587     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
593     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
601     FROM (SELECT count(*) AS cnt, w AS xyz FROM t1 GROUP BY 2)
611     FROM ( SELECT count(*) AS cnt FROM t1 );