Lines Matching refs:AS

71     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
79     FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
87     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
95     FROM (SELECT count(*) as p , y as q FROM t1 GROUP BY y) AS a,
127     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
135     FROM (SELECT count(*),b FROM t2 GROUP BY b) AS a,
143     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY b) AS a,
151     FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
166        FROM (SELECT count(*) as p , b as q FROM t2 GROUP BY q) AS a,
254       (SELECT x AS 'a', y AS 'b', x+y AS 'c' FROM t1 WHERE y=4)
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'
291       (SELECT x+3 AS 'a', x FROM t1 WHERE y=3),
292       (SELECT x AS 'b' FROM t1 WHERE y=4)
309       SELECT x AS 'a' FROM t1 UNION ALL SELECT x+10 AS 'a' FROM t1
316       SELECT x AS 'a' FROM t1 UNION ALL SELECT x+1 AS 'a' FROM t1
323       SELECT x AS 'a' FROM t1 UNION SELECT x+1 AS 'a' FROM t1
330       SELECT x AS 'a' FROM t1 INTERSECT SELECT x+1 AS 'a' FROM t1
337       SELECT x AS 'a' FROM t1 EXCEPT SELECT x*2 AS 'a' FROM t1
351     SELECT c,b,a,* FROM (SELECT 1 AS 'a', 2 AS 'b', 'abc' AS 'c')
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,
394        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
401        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
402        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
409        (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
410        (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
418          (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
419          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
420       WHERE  y=p) AS e,
421       (SELECT r AS z FROM t4 WHERE q=11) AS f
429          (SELECT t1.y AS y, t2.b AS b FROM t1, t2 WHERE t1.x=t2.a) AS m,
430          (SELECT t3.p AS p, t3.q AS q, t4.r AS r FROM t3 NATURAL JOIN t4) as n
431       WHERE  y=p) AS e,
432       (SELECT r AS z FROM t4 WHERE q=11) AS f