Lines Matching refs:sum
31 SELECT sum(b) OVER () FROM t1
35 SELECT a, sum(b) OVER () FROM t1
39 SELECT a, 4 + sum(b) OVER () FROM t1
43 SELECT a + 4 + sum(b) OVER () FROM t1
47 SELECT a, sum(b) OVER (PARTITION BY c) FROM t1
51 1 "SELECT sum(b) OVER () FROM t1"
52 2 "SELECT sum(b) OVER (PARTITION BY c) FROM t1"
53 3 "SELECT sum(b) OVER (ORDER BY c) FROM t1"
54 4 "SELECT sum(b) OVER (PARTITION BY d ORDER BY c) FROM t1"
55 5 "SELECT sum(b) FILTER (WHERE a>0) OVER (PARTITION BY d ORDER BY c) FROM t1"
56 6 "SELECT sum(b) OVER (ORDER BY c RANGE UNBOUNDED PRECEDING) FROM t1"
57 7 "SELECT sum(b) OVER (ORDER BY c ROWS 45 PRECEDING) FROM t1"
58 8 "SELECT sum(b) OVER (ORDER BY c RANGE CURRENT ROW) FROM t1"
59 9 "SELECT sum(b) OVER (ORDER BY c RANGE BETWEEN UNBOUNDED PRECEDING
61 10 "SELECT sum(b) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING
68 1 "SELECT * FROM t1 WHERE sum(b) OVER ()"
69 2 "SELECT * FROM t1 GROUP BY sum(b) OVER ()"
70 3 "SELECT * FROM t1 GROUP BY a HAVING sum(b) OVER ()"
72 do_catchsql_test 3.$tn $sql {1 {misuse of window function sum()}}
87 SELECT a, sum(a) OVER (PARTITION BY b) FROM t2;
93 SELECT a, sum(a) OVER (PARTITION BY b) FROM t2 ORDER BY a;
99 SELECT a, sum(a) OVER () FROM t2 ORDER BY a;
105 SELECT a, sum(a) OVER (ORDER BY a) FROM t2;
111 SELECT a, sum(a) OVER (PARTITION BY b ORDER BY a) FROM t2 ORDER BY a
117 SELECT a, sum(a) OVER (PARTITION BY c ORDER BY a) FROM t2 ORDER BY a
123 SELECT a, sum(a) OVER (PARTITION BY b ORDER BY a DESC) FROM t2 ORDER BY a
130 sum(a) OVER (PARTITION BY b ORDER BY a DESC),
131 sum(a) OVER (PARTITION BY c ORDER BY a)
145 sum(a) OVER (ORDER BY a),
298 sum(b) OVER (ORDER BY c),
304 sum(b) OVER win,
443 SELECT emp, region, sum(total) OVER win FROM sales
457 SELECT emp, region, sum(total) OVER win FROM sales
469 SELECT emp, region, sum(total) OVER win FROM sales
481 SELECT emp, region, sum(total) OVER win FROM sales
498 SELECT emp, region, sum(total) OVER win FROM sales
513 SELECT sum(total) OVER (
530 SELECT sum(total) FILTER (WHERE sales.emp!=outer.emp) OVER (
552 CREATE INDEX t6i ON t6(a) WHERE sum(b) OVER ();
553 } {1 {misuse of window function sum()}}
559 CREATE INDEX t6i ON t6(sum(b) OVER ());
560 } {1 {misuse of window function sum()}}
697 SELECT sum(b)
723 SELECT rowid, sum(a) OVER (PARTITION BY b IN (SELECT rowid FROM t7)) FROM t7;
731 SELECT rowid, sum(a) OVER w1 FROM t7
746 SELECT +sum(0) OVER () ORDER BY +sum(0) OVER ();
750 select +sum(a) OVER () FROM t8 ORDER BY +sum(a) OVER () DESC;
754 SELECT 10+sum(a) OVER (ORDER BY a)
756 ORDER BY 10+sum(a) OVER (ORDER BY a) DESC;
777 SELECT c, sum(d) OVER win2 FROM t1
783 SELECT c, sum(d) OVER win2 FROM t1
789 SELECT c, sum(d) OVER win2 FROM t1
795 SELECT c, sum(d) OVER win2 FROM t1
805 SELECT c, sum(d) OVER (win1 ORDER BY b) FROM t1
810 SELECT c, sum(d) OVER (win4 ORDER BY b) FROM t1
815 SELECT c, sum(d) OVER (win1 PARTITION BY d) FROM t1
820 SELECT c, sum(d) OVER (win1 ORDER BY d) FROM t1
874 SELECT a, sum(b) OVER (ORDER BY a) FROM t1;
878 SELECT a, sum(b) OVER (
883 SELECT a, sum(b) OVER (
889 SELECT a, sum(b) OVER (
894 SELECT a, sum(b) OVER (
909 SELECT a, sum(b) OVER (ORDER BY a) FROM t1;
916 SELECT a, sum(b) OVER (
921 SELECT a, sum(b) OVER (
927 SELECT a, sum(b) OVER (
932 SELECT a, sum(b) OVER (
968 SELECT sum(x) OVER (
977 SELECT sum(x) OVER (
997 sum(c) OVER (ORDER BY a, b),
998 sum(c) OVER (PARTITION BY a ORDER BY b)
1004 sum(c) OVER (ORDER BY b, a),
1005 sum(c) OVER (PARTITION BY b ORDER BY a)
1011 sum(c) OVER (ORDER BY b, a),
1012 sum(c) OVER (ORDER BY c, b)
1018 sum(c) OVER (ORDER BY b ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
1019 sum(c) OVER (ORDER BY b RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
1020 sum(c) OVER (ORDER BY b GROUPS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
1026 sum(c) OVER (ORDER BY b+1 ROWS UNBOUNDED PRECEDING),
1027 sum(c) OVER (ORDER BY b+1 RANGE UNBOUNDED PRECEDING),
1028 sum(c) OVER (ORDER BY b+1 GROUPS UNBOUNDED PRECEDING)
1034 sum(c) OVER (ORDER BY b+1 ROWS UNBOUNDED PRECEDING),
1035 sum(c) OVER (ORDER BY b+2 RANGE UNBOUNDED PRECEDING),
1036 sum(c) OVER (ORDER BY b+3 GROUPS UNBOUNDED PRECEDING)
1041 SELECT sum(44) OVER ()
1239 SELECT d IN (SELECT sum(c) OVER (ORDER BY e+c) FROM t3) FROM (
1245 SELECT d IN (SELECT sum(c) OVER (PARTITION BY d ORDER BY e+c) FROM t3) FROM (
1252 SELECT sum(c) OVER ( ROWS BETWEEN d FOLLOWING AND UNBOUNDED FOLLOWING)
1262 SELECT sum(c) OVER ( ROWS BETWEEN CURRENT ROW AND c FOLLOWING)
1290 SELECT (SELECT DISTINCT sum(aa) OVER() FROM t1 ORDER BY 1), x FROM t2
1300 ORDER BY (SELECT sum(b) OVER ()
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;
1461 SELECT sum(a), max(b) OVER () FROM t1;
1475 SELECT a, sum(b), sum( sum(b) ) OVER (ORDER BY a) FROM t2 GROUP BY a;
1479 SELECT sum(b), sum( sum(b) ) OVER (ORDER BY a) FROM t2;
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)
1565 SELECT sum (a) OVER() FROM t1 UNION ALL SELECT x FROM t0
1579 SELECT (SELECT sum(a) OVER(ORDER BY a)) FROM t1
1583 SELECT * FROM t1 WHERE (SELECT sum(a) OVER(ORDER BY a));
1589 OR ((SELECT sum(a)OVER(ORDER BY a)) AND a<=10)
1612 OR (SELECT k FROM t2 WHERE (SELECT sum(a) OVER() FROM t1 GROUP BY 1));
1613 } {1 {misuse of window function sum()}}
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);
1641 SELECT a FROM t1 WHERE a=1 OR (SELECT sum(a) OVER ())
1657 SELECT * FROM t1 WHERE a%1 OR (SELECT sum(a) OVER (ORDER BY a%2))
1662 SELECT * FROM t1 WHERE a%1 OR (SELECT sum(a) OVER (ORDER BY a%2))
1664 WHERE a=1 OR ( (SELECT sum(a) OVER (ORDER BY a%4)) AND a<=10 )
1670 SELECT * FROM t1 WHERE a%1 OR (SELECT sum(a) OVER (ORDER BY a%2))
1672 WHERE a=1 OR ( (SELECT sum(a) OVER (ORDER BY a%4)) AND a<=10 )
1680 SELECT * FROM t1 WHERE a%1 OR (SELECT sum(a) OVER (ORDER BY a%2))
1682 WHERE a=1 OR ( (SELECT sum(a) OVER (ORDER BY a%4)) AND a<=10 )
1684 WHERE a=1 OR ((SELECT sum(a) OVER(ORDER BY a%8)) AND 10<=a)
1688 …sum(a)OVER(ORDER BY a)) AND a<=10)) NATURAL JOIN t1 WHERE a=1 OR ((SELECT sum((SELECT * FROM (SELE…
1697 HAVING(SELECT(sum(b) OVER(ORDER BY b),
1698 sum(b) OVER(PARTITION BY min(DISTINCT c), c ORDER BY b)));
1714 sum(c) OVER win2,
1732 sum(c) OVER win2,
1750 sum(c) OVER win2,
1776 WHERE a.c=(SELECT (SELECT coalesce(lead(2) OVER(),0) + sum(d.c))
1790 SELECT sum(b) OVER() AS c FROM t1
1803 SELECT sum(b) OVER() AS c FROM t1
1847 SELECT sum(x) OVER() FROM (
1864 sum(a),
1881 SELECT max(y) OVER( ORDER BY (SELECT x FROM (SELECT sum(y) AS x FROM t1)))
1884 } {1 {misuse of aggregate: sum()}}
1892 SELECT sum(345+b) OVER (ORDER BY b),
1893 sum(avg(678)) OVER (ORDER BY c) FROM a;
1902 ntile( (SELECT sum(x)) ) OVER(ORDER BY x),
1905 } {1 {misuse of aggregate: sum()}}
1912 SELECT EXISTS(SELECT count(*) OVER() FROM t1 ORDER BY sum(x) OVER());
1924 …sum(CAST(a IN(SELECT (SELECT max(x)OVER(ORDER BY CASE x WHEN 889 THEN 299 WHEN 863 THEN 863 END)) …
1933 SELECT (SELECT sum(a) FROM t1 ) AS x FROM t1
1948 SELECT count(a) OVER ( ORDER BY (SELECT sum(y) FROM t2) )
1955 SELECT count(a) OVER ( ORDER BY sum(a) )
1963 sum(a) OVER ( ORDER BY a )
1965 ORDER BY (SELECT sum(a) FROM t2)
1966 } {1 {misuse of aggregate: sum()}}
1969 sum(a) OVER ( ORDER BY a )
1971 ORDER BY (SELECT sum(y) FROM t2)
1984 SELECT sum(b) OVER() AS c FROM t1
1997 SELECT sum(b) OVER() AS c FROM t1
2020 SELECT sum(b) over(
2023 ORDER BY sum(
2082 ORDER BY sum('abcdef' COLLATE nocase) IN (SELECT 54321)
2162 SELECT rowid, a, b, sum(a)OVER() FROM t1 ORDER BY count(b);
2172 SELECT * FROM t1 WHERE b = (SELECT b FROM t1 ORDER BY lead(b) OVER () AND sum(a));
2173 } {1 {misuse of aggregate: sum()}}
2175 SELECT * FROM t1 WHERE b >= (SELECT b FROM t1 ORDER BY lead(b) OVER () AND sum(a));
2176 } {1 {misuse of aggregate: sum()}}
2178 SELECT * FROM t1 WHERE b <= (SELECT b FROM t1 ORDER BY lead(b) OVER () AND sum(a));
2179 } {1 {misuse of aggregate: sum()}}
2202 WHERE (a,1)=(SELECT 2,2 UNION SELECT sum(b),max(b) OVER(ORDER BY b) ORDER BY 2)