Lines Matching refs:AS
224 WINDOW w AS (ORDER BY x)
259 SELECT max(x) OVER abc FROM t1 WINDOW def AS (ORDER BY y);
271 WINDOW win AS (ORDER BY x)
285 WINDOW win AS (ORDER BY x ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
294 WITH s(i) AS ( VALUES(1) UNION ALL SELECT i+1 FROM s WHERE i<6 )
297 CREATE VIEW v1 AS SELECT
303 CREATE VIEW v2 AS SELECT
308 WINDOW win AS (ORDER BY c);
343 WINDOW xyz AS (PARTITION BY (x%2) ORDER BY x);
349 WINDOW xyz AS (PARTITION BY (x%2) ORDER BY x) ORDER BY 1
355 WINDOW xyz AS (PARTITION BY (x%2) ORDER BY x) ORDER BY 1
363 WITH aaa(x, y, z) AS (
365 WINDOW xyz AS (PARTITION BY (x%2) ORDER BY x)
371 WITH aaa(x, y, z) AS (
373 WINDOW xyz AS (ORDER BY x)
387 WINDOW w1 AS (PARTITION BY EXISTS(SELECT 1 FROM t1 WHERE c=?1) );
395 WINDOW w1 AS (
404 WINDOW w1 AS (
431 row_number() OVER (PARTITION BY region ORDER BY total DESC) AS rank
444 WINDOW win AS (PARTITION BY region ORDER BY total)
458 WINDOW win AS (PARTITION BY region ORDER BY total)
470 WINDOW win AS (PARTITION BY region ORDER BY total)
482 WINDOW win AS (
499 WINDOW win AS (
516 ) FROM sales AS outer;
533 ) FROM sales AS outer;
576 SELECT id, b, lead(c,1) OVER(ORDER BY c) AS x
583 SELECT id, b, lead(c,1) OVER(ORDER BY c) AS x
644 SELECT * FROM (SELECT 1 AS c) WHERE c IN (
655 ) AS y FROM t2
664 WITH t(id, parent) AS (
665 SELECT CAST(1 AS INT), CAST(NULL AS INT)
676 ), q AS (
677 SELECT t.*, ROW_NUMBER() OVER (ORDER BY t.id) AS rn
681 SELECT t.*, ROW_NUMBER() OVER (ORDER BY t.id) AS rn
706 WITH c AS(
732 WINDOW w1 AS (PARTITION BY b IN (SELECT rowid FROM t7));
778 WINDOW win1 AS (ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING),
779 win2 AS (win1 ORDER BY b)
784 WINDOW win1 AS (),
785 win2 AS (win4 ORDER BY b)
790 WINDOW win1 AS (),
791 win2 AS (win1 PARTITION BY d)
796 WINDOW win1 AS (ORDER BY b),
797 win2 AS (win1 ORDER BY d)
806 WINDOW win1 AS (ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)
811 WINDOW win1 AS ()
816 WINDOW win1 AS ()
821 WINDOW win1 AS (ORDER BY b)
835 WINDOW win1 AS (PARTITION BY b)
841 WINDOW win1 AS (PARTITION BY b),
842 win2 AS (win1 ORDER BY c)
848 WINDOW win1 AS (PARTITION BY b),
849 win2 AS (win1 ORDER BY c)
855 WINDOW win1 AS (PARTITION BY b),
856 win2 AS (win1),
857 win3 AS (win2),
858 win4 AS (win3),
859 win5 AS (win4 ORDER BY c)
967 WITH a(x, y) AS ( VALUES(1, 2) )
976 WITH a(x, y) AS ( VALUES(1, 2) )
1117 WINDOW win AS (ORDER BY rowid ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)
1131 WINDOW w1 AS (ORDER BY a RANGE BETWEEN 3 PRECEDING AND 1 PRECEDING)
1153 WINDOW w1 AS
1186 WINDOW w1 AS
1220 WINDOW win1 AS (ORDER BY a GROUPS BETWEEN 4 PRECEDING AND 1 FOLLOWING
1222 win2 AS (PARTITION BY b ORDER BY a),
1223 win3 AS (win2 RANGE BETWEEN 5.2 PRECEDING AND true PRECEDING );
1275 CREATE VIEW a AS SELECT NULL INTERSECT SELECT NULL ORDER BY s() OVER R;
1276 CREATE TABLE a0 AS SELECT 0;
1303 FROM (SELECT 1 AS d) ORDER BY 1
1313 SELECT * WINDOW f AS () ORDER BY name COLLATE nocase;
1317 VALUES(1) INTERSECT SELECT * WINDOW f AS () ORDER BY x COLLATE nocase;
1324 SELECT sum(x) OVER f FROM t1 WINDOW f AS (ORDER BY x) ORDER BY 1;
1329 SELECT sum(x) OVER f FROM t1 WINDOW f AS (ORDER BY x) ORDER BY 1;
1334 SELECT sum(x) OVER f FROM t1 WINDOW f AS (ORDER BY x) ORDER BY 1;
1358 CREATE VIEW v0(c) AS SELECT max((SELECT count(a)OVER(ORDER BY 1))) FROM t0;
1363 CREATE VIEW v0(c) AS SELECT max((SELECT count(a)OVER(ORDER BY 1234))) FROM t0;
1437 WINDOW win3 AS (
1489 SELECT count() OVER() AS m FROM t1 ORDER BY (SELECT m);
1504 SELECT a, sum(b) OVER (ORDER BY a) AS abc FROM t1 ORDER BY 2
1510 SELECT a, sum(b) OVER (ORDER BY a) AS abc FROM t1 ORDER BY abc
1516 SELECT a, sum(b) OVER (ORDER BY a) AS abc FROM t1 ORDER BY abc+5
1522 SELECT a, sum(b) OVER (ORDER BY a) AS abc FROM t1 ORDER BY (SELECT abc)
1526 SELECT a, 1+sum(b) OVER (ORDER BY a) AS abc FROM t1 ORDER BY (SELECT abc)
1605 CREATE VIEW t2(k) AS
1623 FROM (SELECT (SELECT sum(a) FROM t1) AS x FROM t1);
1628 FROM (SELECT (SELECT sum(a) FROM t1 GROUP BY a) AS x FROM t1);
1639 SELECT b AS c FROM (
1640 SELECT a AS b FROM (
1719 win1 AS (ORDER BY a),
1720 win2 AS (PARTITION BY 6 ORDER BY a
1737 win1 AS (ORDER BY a),
1738 win2 AS (PARTITION BY 6 COLLATE binary ORDER BY a
1755 win1 AS (ORDER BY a),
1756 win2 AS (PARTITION BY 6 COLLATE binary ORDER BY a
1774 JOIN a AS b ON a.c=4
1775 JOIN a AS e ON a.c=e.c
1777 FROM a AS d
1790 SELECT sum(b) OVER() AS c FROM t1
1792 SELECT b AS c FROM t1
1803 SELECT sum(b) OVER() AS c FROM t1
1805 SELECT b AS c FROM t1
1848 SELECT c AS x FROM t4
1881 SELECT max(y) OVER( ORDER BY (SELECT x FROM (SELECT sum(y) AS x FROM t1)))
1924 …SELECT sum(CAST(a AS )) FROM t1) AS x FROM t1)) AS t1 )) FROM t1) AS x FROM t1)) AS x )) FROM t1) …
1933 SELECT (SELECT sum(a) FROM t1 ) AS x FROM t1
1984 SELECT sum(b) OVER() AS c FROM t1
1986 SELECT b AS c FROM t1
1997 SELECT sum(b) OVER() AS c FROM t1
1999 SELECT b AS c FROM t1
2024 (SELECT x AS c UNION SELECT 1234 ORDER BY c)
2026 ) AS e
2142 WINDOW w1 AS ( ORDER BY ((SELECT 1 FROM v1)) )
2149 WINDOW w1 AS ( ORDER BY ((SELECT 1 FROM t2)) )
2189 SELECT substr(a,4,lag(a,7) OVER(PARTITION BY 'cf23' ORDER BY 2)) AS ca0 FROM t1 ORDER BY ca0;
2192 …SELECT substr(a,4,lag(a,7) OVER(PARTITION BY 'cf23' ORDER BY likely(2))) AS ca0 FROM t1 ORDER BY c…
2201 SELECT a FROM t0, (SELECT a AS b FROM t0)
2209 CREATE VIEW v1(x,y) AS SELECT RANK() OVER (PARTITION BY 0), SUM(0) FROM dual;