Lines Matching refs:sum

37   SELECT sum(b) FROM t1
41   SELECT sum(b) FILTER (WHERE a<10) FROM t1
83   SELECT sum(a+b) FILTER (WHERE a=NULL) FROM t1
88   HAVING sum(b) FILTER (WHERE b<20) > 34
93   SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
95   GROUP BY (a%5) HAVING sum(b) FILTER (WHERE b<20) >34
100   SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
102   GROUP BY (a%5) HAVING sum(b) FILTER (WHERE b<20) >34
108     sum(b) FILTER (WHERE b<20) AS bbb,
146     sum(b) FILTER (WHERE a%5=0),
147     sum(b) FILTER (WHERE a%5=1),
148     sum(b) FILTER (WHERE a%5=2),
149     sum(b) FILTER (WHERE a%5=3),
150     sum(b) FILTER (WHERE a%5=4)