Lines Matching refs:AS

60     CREATE TABLE t2 AS
71     CREATE TABLE t2 AS
89     CREATE TABLE t2 AS 
161   SELECT 123 AS x ORDER BY (SELECT x ORDER BY 1);
176     CREATE TABLE t2 AS 
187     CREATE TABLE t2 AS 
240     CREATE TABLE t2 AS
251     CREATE TABLE t2 AS
303     SELECT DISTINCT log AS "xyzzy" FROM t1
312     SELECT DISTINCT log AS xyzzy FROM t1
445     SELECT 1 UNION SELECT 2 AS 'x'
452     SELECT 1 UNION ALL SELECT 2 AS 'x'
497     CREATE TABLE t2 AS SELECT log AS 'x', count(*) AS 'y' FROM t1 GROUP BY log;
569     SELECT x, y FROM t2 INTERSECT SELECT 0 AS a, 1 AS b;
574     SELECT 0 AS x, 1 AS y
576     SELECT 2 AS p, 3 AS q
578     SELECT 4 AS a, 5 AS b
587       SELECT 0 AS x, 1 AS y
589       SELECT 2 AS p, 3 AS q
591       SELECT 4 AS a, 5 AS b
598       SELECT 0 AS x, 1 AS y
600       SELECT 2 AS p, 3 AS q
602       SELECT 4 AS a, 5 AS b
610     SELECT 0 AS x, 1 AS y
612     SELECT 2 AS y, -3 AS x
619     SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS b, 4 AS a
626     SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS b, 4 AS a)
632     SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS b, 4 AS a)
638     SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS e, 4 AS b)
644     SELECT * FROM (SELECT 1 AS a, 2 AS b UNION ALL SELECT 3 AS e, 4 AS b)
929     FROM tx AS t0, tx AS t1
933     FROM tx AS t0, tx AS t1
946   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
951     (SELECT a,max(b) AS m FROM t1 WHERE a>=5 GROUP BY a) AS t2
952     JOIN t1 AS t3
958     (SELECT a,max(b) AS m FROM t1 WHERE a>=5 GROUP BY a) AS t2
959     CROSS JOIN t1 AS t3
965     (SELECT a,max(b) AS m FROM t1 WHERE a>=5 GROUP BY a) AS t2
966     LEFT JOIN t1 AS t3
985     SELECT 98 AS x, 99 AS y
987     SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a
988   ) AS w WHERE y>=20
993     SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a
995     SELECT 98 AS x, 99 AS y
996   ) AS w WHERE y>=20
1001     SELECT a AS x, sum(b) AS y FROM t1 GROUP BY a LIMIT 3
1003     SELECT 98 AS x, 99 AS y
1004   ) AS w WHERE y>=20
1014   CREATE VIEW v0(v0) AS WITH v0 AS(SELECT 0 v0) SELECT(SELECT min(v0) OVER()) FROM v0 GROUP BY v0;
1018   CREATE VIEW t1(aa) AS
1019      WITH t2(bb) AS (SELECT 123)
1024   SELECT * FROM t1 AS z1 JOIN t1 AS z2 USING(aa)