Lines Matching refs:AS

27     SELECT sum(b) OVER w FROM t1 WINDOW w AS (ORDER BY a);
38     SELECT sum(b) OVER w FROM t1 WINDOW w AS (ORDER BY aaa);
73   CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (b IN ());
82 } {{CREATE VIEW v1 AS SELECT * FROM t1 WHERE a=1 OR (b IN ())}}
151     WINDOW w1 AS (PARTITION BY b, percent_rank() OVER w1);
162     WINDOW w1 AS (PARTITION BY b, percent_rank() OVER w1);
170     WINDOW w1 AS (PARTITION BY b, percent_rank() OVER w1 ORDER BY d);
226   CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
235   {CREATE VIEW v1 AS SELECT * FROM t1 WHERE (
250     WINDOW b AS (ORDER BY NOT EXISTS(SELECT 1 FROM abc));
262     WINDOW b AS (ORDER BY NOT EXISTS(SELECT 1 FROM t1));
272     WINDOW b AS (ORDER BY NOT EXISTS(SELECT 1 FROM "t1x"));
286 w1 AS
290 w1 AS
293 d AS
297 w2 AS
299 w3 AS
305 w1 AS
308 d AS
353     SELECT (WITH t2 AS (WITH t3 AS (SELECT true)
357     WITH t4 AS (SELECT * FROM t1) SELECT 33;
422     CREATE VIEW q AS SELECT 123
424       WINDOW x AS (
426           PARTITION BY ( WITH x AS(VALUES(col1)) VALUES(453) )
433     CREATE VIEW q AS SELECT
435     AS)AS)AS)AS)AS)AS)AS)AS)AS)AS)AS)WINDOW x AS(RANGE BETWEEN UNBOUNDED
437     CROSS,CROSS,NATURAL,sqlite_master(*)OVER a,(WITH a AS(VALUES(LEFT)UNION
453     CREATE VIEW q AS SELECT 99 WINDOW x AS (RANGE BETWEEN UNBOUNDED PRECEDING
454     AND count(*)OVER(PARTITION BY (WITH a AS(VALUES(2),(x3))VALUES(0)))
474   CREATE INDEX k ON s( (WITH s AS( SELECT * ) VALUES(2) ) IN () );
483   CREATE VIEW v AS SELECT ( 
484     WITH x(a) AS(SELECT * FROM s) VALUES(RIGHT) 
495   CREATE VIEW v2(b) AS SELECT * FROM v2;
504   CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) SELECT * FROM t3;
513   CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
539   CREATE VIEW v2 (v3) AS 
540     WITH x1 AS (SELECT * FROM v2) 
541     SELECT v3 AS x, v3 AS y FROM v2; 
562       ( SELECT v1 AS PROMO_REVENUE FROM v2 JOIN v0 USING ( VALUE ) ) AND 0 ) 
617     UPDATE t3 SET y=abc FROM (SELECT x AS abc FROM t1);
633     UPDATE t3 SET y=abc FROM (SELECT xx AS abc FROM "t2");
655   CREATE TABLE t1(a, b AS ((WITH w1 (xyz) AS  ( SELECT t1.b FROM t1 )  SELECT 123) IN ()), c);
662   {CREATE TABLE t1(a, b AS ((WITH w1 (xyz) AS  ( SELECT t1.b FROM t1 )  SELECT 123) IN ()))}
666 …AS (CASE TRUE   NOT IN () WHEN NULL   THEN CASE + 0xa     ISNULL  WHEN NOT + 0x9     THEN t0.c1  E…