Lines Matching refs:AS

28   WITH i(x) AS (
29     WITH j AS (SELECT 10)
37   CREATE VIEW v1(x,y) AS
38     WITH t1(a,b) AS (VALUES(1,2))
48   x1 AS (SELECT 10),
49   x2 AS (SELECT 11),
50   x3 AS (
53   x4 AS (
55     x1 AS (SELECT 12),
56     x2 AS (SELECT 13)
66     x1(a) AS (values(100))
68     SELECT * FROM (WITH x2(y) AS (SELECT * FROM x1) SELECT y+a FROM x1, x2);
81     WITH cnt(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM cnt LIMIT 1000)
88     WITH cnt(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM cnt LIMIT 1)
102     WITH cnt(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM cnt LIMIT 1000000)
122   WITH RECURSIVE c(w,id) AS (SELECT 0, (SELECT pk FROM w2 LIMIT 1)
142   WITH t5(t5col1) AS (
144       WITH t3(t3col1) AS (
145         WITH t2 AS (
146           WITH t1 AS (SELECT 1 AS c1 GROUP BY 1) 
147           SELECT a.c1 FROM t1 AS a, t1 AS b
153     ) FROM (SELECT 1 AS anoncol1)
159     WITH RECURSIVE Table0 AS (
160       WITH RECURSIVE Table0(Col0) AS (SELECT ALL 1  ) 
162         WITH RECURSIVE Table0 AS (
163           WITH RECURSIVE Table0 AS (
164             WITH RECURSIVE Table0 AS (SELECT DISTINCT 1  GROUP BY 1  ) 
185     WITH t1(a) AS (VALUES(1))
187       WITH t2(b) AS (
188         WITH t3(c) AS (
189           WITH t4(d) AS (VALUES('elvis'))
190           SELECT t4a.d FROM t4 AS t4a JOIN t4 AS t4b LEFT JOIN t4 AS t4c
194       SELECT t2a.b FROM t2 AS t2a JOIN t2 AS t2x
205   WITH RECURSIVE c(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c WHERE x<1)
206   SELECT x1.x||x2.x||x3.x||x4.x FROM c AS x1, c AS x2, c AS x3, c AS x4
222   WITH RECURSIVE c(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM c WHERE x<1)
223   SELECT x1.x||x2.x||x3.x||x4.x FROM c AS x1, c AS x2, c AS x3, c AS x4
232     cte1(x, y) AS ( select 1, 2, 3 ),
239     cte1(x, y) AS ( select 1, 2, 3 ),