Lines Matching refs:AS

73     SELECT sum(%x) OVER %w FROM %t1 WINDOW %w AS (ORDER BY %y)
77     SELECT sum(%alias.%x) OVER %w FROM %t1 %alias WINDOW %w AS (ORDER BY %y)
127   SELECT sum(x) over over FROM over WINDOW over AS ()
131   SELECT sum(over) over over over FROM over over WINDOW over AS (ORDER BY over)
135   SELECT sum(over) over over over FROM over over WINDOW over AS (ORDER BY over);
139   SELECT sum(window) OVER window window FROM window window window window AS (ORDER BY window);
144   WINDOW win AS (ORDER BY x ROWS BETWEEN +2 FOLLOWING AND +3 FOLLOWING)
190   SELECT "counter", "value", RANK() OVER w AS "rank" 
192   WINDOW w AS (PARTITION BY "counter" ORDER BY "value" DESC) 
217   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
224 #  WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
230 #  WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
236   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
241   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
246   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
251   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
262     WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
270   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
276   WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<5)
283   WITH t1(a,b) AS (VALUES(1,2))
286     WINDOW w1 AS (ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING);
297     WITH t1(a,b) AS ( VALUES(1, 2), (2, 3), (3, 4) )
311     WITH t1(a,b) AS ( VALUES(1, 2), (2, 3), (3, 4) )
343   WINDOW win AS (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
349   WINDOW win AS (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 0 FOLLOWING)
355   WINDOW win AS (ORDER BY a ROWS BETWEEN UNBOUNDED PRECEDING AND 0 PRECEDING)
362   WINDOW win AS (