Lines Matching refs:sum

109   SELECT EXISTS(SELECT 1 FROM t1 ORDER BY sum(a) OVER ()) FROM t1;
113   SELECT sum(a) OVER () FROM t2
114    ORDER BY EXISTS(SELECT 1 FROM t2 ORDER BY sum(a) OVER ());
118   SELECT a, sum(a) OVER (ORDER BY a DESC) FROM t2 
120     SELECT 1 FROM t2 ORDER BY sum(a) OVER (ORDER BY a)
158       sum(e) OVER (),
159       sum(e) OVER (ORDER BY a),
160       sum(e) OVER (PARTITION BY a ORDER BY b),
161       sum(e) OVER (PARTITION BY a, b ORDER BY c),
162       sum(e) OVER (PARTITION BY a, b, c ORDER BY d)
166     SELECT sum(e) OVER (PARTITION BY a ORDER BY b) FROM t1 ORDER BY a;
240   SELECT min( sum(a) ) OVER () FROM t1;
244   SELECT min( sum(a) ) OVER () FROM t1 GROUP BY a;
263       SELECT sum( avg((SELECT x FROM v1)) ) OVER()
279   SELECT sum(c) OVER (