Lines Matching refs:AS
31 WITH x1 AS (SELECT * FROM t1)
36 WITH x1 AS (SELECT * FROM t1)
41 WITH x1 AS (SELECT * FROM t1)
51 WITH x1 AS (SELECT i FROM t2),
52 i(a) AS (
59 WITH x1 AS (SELECT a FROM t1),
60 x2 AS (SELECT i FROM t2),
61 x3 AS (SELECT * FROM x1, x2 WHERE x1.a IN x2 AND x2.i IN x1)
66 CREATE TABLE t3 AS SELECT 3 AS x;
67 CREATE TABLE t4 AS SELECT 4 AS x;
69 WITH x1 AS (SELECT * FROM t3),
70 x2 AS (
71 WITH t3 AS (SELECT * FROM t4)
78 WITH x2 AS (
79 WITH t3 AS (SELECT * FROM t4)
86 WITH x2 AS (
87 WITH t3 AS (SELECT * FROM t4)
94 WITH x1 AS (SELECT * FROM t1)
99 WITH x1 AS (SELECT * FROM t1)
105 i(x) AS (
107 j(x) AS ( SELECT * FROM i ),
108 i(x) AS ( SELECT * FROM t1 )
115 WITH r(i) AS (
122 x(x) AS ( VALUES(1) UNION ALL VALUES(2) UNION ALL VALUES(3) ),
123 y(y) AS ( VALUES(2) UNION ALL VALUES(4) UNION ALL VALUES(6) )
129 WITH r(i) AS (
134 x(x) AS ( VALUES(1) UNION ALL VALUES(2) UNION ALL VALUES(3) )
141 t4(x) AS (
151 t4(x) AS (
161 t4(x) AS (
176 WITH i(x) AS (
183 WITH i(x) AS (
186 SELECT x FROM i JOIN i AS j USING (x);
193 WITH i(x, y) AS ( VALUES(1, (SELECT x FROM i)) )
199 i(x) AS ( SELECT * FROM j ),
200 j(x) AS ( SELECT * FROM k ),
201 k(x) AS ( SELECT * FROM i )
207 i(x) AS ( SELECT * FROM (SELECT * FROM j) ),
208 j(x) AS ( SELECT * FROM (SELECT * FROM i) )
214 i(x) AS ( SELECT * FROM (SELECT * FROM j) ),
215 j(x) AS ( SELECT * FROM (SELECT * FROM i) )
221 i(x) AS (
222 WITH j(x) AS ( SELECT * FROM i )
232 WITH x() AS ( SELECT 1,2,3 )
242 WITH x([join $cols ,]) AS (SELECT [join $vals ,])
279 WITH x AS (SELECT a, b FROM t2) INSERT INTO t1 SELECT * FROM x
282 WITH x AS (SELECT a, b FROM t2) INSERT INTO t1 SELECT * FROM t2
285 INSERT INTO t1 WITH x AS ( SELECT * FROM t2 ) SELECT * FROM x
288 INSERT INTO t1 WITH x(a,b) AS ( SELECT * FROM t2 ) SELECT * FROM x
303 WITH x AS (SELECT * FROM t1)
308 WITH x AS (SELECT * FROM t1)
313 WITH x AS (SELECT * FROM t1)
318 WITH x AS (SELECT * FROM t1)
323 WITH x AS (SELECT * FROM t1)
328 WITH x AS (SELECT * FROM t1) DELETE FROM t2 WHERE
332 WITH x AS (SELECT * FROM t1) DELETE FROM t2 WHRE 1;
336 WITH x AS (SELECT * FROM t1) UPDATE t2 SET a = 10, b = ;
340 WITH x AS (SELECT * FROM t1) UPDATE t2 SET a = 10, b = 1 WHERE a===b;
344 WITH x(a,b) AS (
359 WITH s(x) AS ( VALUES(7) UNION ALL SELECT x+7 FROM s WHERE x<49 )
364 WITH s(x) AS ( VALUES(2) UNION ALL SELECT x+2 FROM s WHERE x<49 )
373 WITH ss AS (SELECT x FROM t5)
378 WITH ss(x) AS ( VALUES(7) UNION ALL SELECT x+7 FROM ss WHERE x<49 )
384 WITH ss(x) AS ( VALUES(7) UNION ALL SELECT x+7 FROM ss WHERE x<49 )
396 CREATE VIEW v AS SELECT * FROM t7 ORDER BY y;
400 WITH q(a) AS (
409 WITH q(a) AS (
421 WITH xyz(a) AS (
422 WITH abc AS ( SELECT 1234 ) SELECT * FROM abc
424 SELECT * FROM xyz AS one, xyz AS two, (
432 cst(rsx, rsy) AS (
435 cst2(minx, maxx, stepx, miny, maxy, stepy, qualitativex, qualitativey) AS (
438 ds0(m, n, x, y, x2, y2, title, size, mark, label, markmode) AS (
441 ds(m, n, x, y, x2, y2, title, size, mark, label, markmode) AS (
447 WINDOW w AS (PARTITION BY m, x ORDER BY n)
449 d(m, n, x, y, x2, y2, labelx,labely,title,size,mark,label,markmode) AS (
453 ylabels(y, label) AS (
456 yaxis(maxy, miny, stepy , minstepy) AS (
458 xt0(minx, maxx) AS (
464 xt1(mx, mn) AS (SELECT maxx, minx FROM xt0),
465 xt2(mx, mn, step) AS (SELECT mx, mn, (mx-mn) FROM xt1),
467 xt3(mx, mn, ms) AS (
468 SELECT mx, mn, first_value(rs) OVER (order by x desc) AS ms
470 1.0*step/f as rs, 1.0*(mx-mn)/(step/f) AS x
471 FROM xt2, (SELECT 1 AS f UNION ALL SELECT 2
473 UNION ALL SELECT 5)) AS src
475 xt4(minstepy) AS (
481 distinct_mark_n_m(mark, ze, zem, title) AS (
482 SELECT DISTINCT mark, n AS ze, m AS zem, title FROM ds0
484 facet0(m, mi, title, radial) AS (
487 FROM (SELECT DISTINCT zem AS md, title AS title
490 facet(m, mi, xorigin, yorigin, title, radial) AS (
508 radygrid(m, mi, tty, wty, ttx, ttx2, xorigin, yorigin) AS (
509 SELECT m, mi, rsy / 2 / ((maxy-miny)/stepy) * (value-1) AS tty,
510 coalesce(NULL, miny + stepy * (value-1)) AS wty,
517 ypos(m, mi, pcx, pcy, radial) AS (
543 SELECT 1 AS c WHERE (
545 WITH t1(a) AS (VALUES( c ))
546 SELECT ( SELECT t1a.a FROM t1 AS t1a, t1 AS t1x )
547 FROM t1 AS xyz GROUP BY 1
559 CREATE VIEW v2(c) AS
560 WITH x AS (
561 WITH y AS (
562 WITH z AS(SELECT * FROM t1)
575 CREATE VIEW v2(c) AS
576 WITH x AS (
577 WITH y AS (
578 WITH z AS(SELECT * FROM t1)
586 CREATE VIEW v2(c) AS
587 WITH x AS (
588 WITH y AS (
589 WITH z AS(SELECT * FROM t1)
596 WITH x AS (
597 WITH y AS (
598 WITH z AS(SELECT * FROM t1)
611 …CREATE VIEW v2(c) AS WITH x AS (WITH y AS (WITH z AS(SELECT * FROM t1) SELECT * FROM v2) SELECT a)…
612 …CREATE VIEW v3(c) AS WITH x AS (WITH y AS (WITH z AS(SELECT * FROM v2) SELECT * FROM v3) SELECT a)…
622 t1(x) AS (SELECT 111),
623 t2(y) AS (SELECT 222),
624 t3(z) AS (SELECT * FROM t2 WHERE false UNION ALL SELECT * FROM t2)