Lines Matching refs:sum
60 SELECT a, sum(b) FROM t1 GROUP BY a ORDER BY a
63 SELECT a, sum(b) FROM t1 GROUP BY a ORDER BY a DESC
67 SELECT a, sum(b) FROM t1 GROUP BY a ORDER BY a||''
70 SELECT a, sum(b) FROM t1 GROUP BY a ORDER BY a||'' DESC
74 SELECT a, sum(b) FROM t1 GROUP BY a ORDER BY a NULLS LAST
77 SELECT a, sum(b) FROM t1 GROUP BY a ORDER BY a DESC NULLS FIRST
121 SELECT a, b, sum(c) FROM t2 GROUP BY a, b ORDER BY a, b;
124 SELECT a, b, sum(c) FROM t2 GROUP BY a, b ORDER BY a DESC, b DESC;
129 SELECT a, b, sum(c) FROM t2 GROUP BY a, b ORDER BY a, b DESC;
132 SELECT a, b, sum(c) FROM t2 GROUP BY a, b ORDER BY a DESC, b;
139 SELECT a, b, sum(c) FROM t2 GROUP BY a, b ORDER BY a, b DESC NULLS FIRST;
142 SELECT a, b, sum(c) FROM t2 GROUP BY a, b ORDER BY a DESC, b NULLS LAST;