Home
last modified time | relevance | path

Searched refs:sum (Results 1 – 25 of 132) sorted by relevance

123456

/sqlite-3.40.0/test/
H A Dwindow2.test49 SELECT a, sum(d) OVER (
56 SELECT a, sum(d) OVER (
63 SELECT a, sum(d) OVER (
70 SELECT a, sum(d) OVER (
77 SELECT a, sum(d) OVER (
84 SELECT a, sum(d) OVER (
92 SELECT a, sum(d) OVER (
100 SELECT a, sum(d) OVER (
107 SELECT a, sum(d) OVER (
114 SELECT a, sum(d) OVER (
[all …]
H A Dwindow2.tcl47 SELECT a, sum(d) OVER (
53 SELECT a, sum(d) OVER (
59 SELECT a, sum(d) OVER (
65 SELECT a, sum(d) OVER (
71 SELECT a, sum(d) OVER (
78 SELECT a, sum(d) OVER (
86 SELECT a, sum(d) OVER (
94 SELECT a, sum(d) OVER (
101 SELECT a, sum(d) OVER (
108 SELECT a, sum(d) OVER (
[all …]
H A Dwindow1.test304 sum(b) OVER win,
697 SELECT sum(b)
746 SELECT +sum(0) OVER () ORDER BY +sum(0) OVER ();
750 select +sum(a) OVER () FROM t8 ORDER BY +sum(a) OVER () DESC;
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;
1714 sum(c) OVER win2,
1732 sum(c) OVER win2,
1750 sum(c) OVER win2,
1864 sum(a),
[all …]
H A Dfilter1.test33 SELECT sum(a) FILTER( WHERE a>9 ),
34 sum(a) FILTER( WHERE a>8 ),
35 sum(a) FILTER( WHERE a>7 ),
36 sum(a) FILTER( WHERE a>6 ),
37 sum(a) FILTER( WHERE a>5 ),
38 sum(a) FILTER( WHERE a>4 ),
39 sum(a) FILTER( WHERE a>3 ),
40 sum(a) FILTER( WHERE a>2 ),
41 sum(a) FILTER( WHERE a>1 ),
42 sum(a) FILTER( WHERE a>0 )
[all …]
H A Dwindow4.test247 SELECT sum(b) OVER (
284 sum(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
332 sum(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
355 SELECT sum(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
367 SELECT sum(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
380 sum(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
428 sum(c) OVER ( ORDER BY a RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
1328 SELECT sum( min(t) ) OVER () FROM t8 GROUP BY total;
1332 SELECT sum( max(t) ) OVER () FROM t8 GROUP BY total;
1336 SELECT sum( min(t) ) OVER () FROM t8;
[all …]
H A Dhaving.test32 1 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING a=2" {2 12}
33 2 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING a=2 AND sum(b)>10" {2 12}
34 3 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING sum(b)>12" {}
59 1 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING a=2"
60 "SELECT a, sum(b) FROM t1 WHERE a=2 GROUP BY a"
62 2 "SELECT a, sum(b) FROM t1 GROUP BY a HAVING sum(b)>5 AND a=2"
63 "SELECT a, sum(b) FROM t1 WHERE a=2 GROUP BY a HAVING sum(b)>5"
93 SELECT a AS x, sum(b) AS y FROM t1
99 SELECT a AS x, sum(b) AS y FROM t1
146 SELECT a, sum(b) FROM t3 GROUP BY a HAVING nondeter(a)
[all …]
H A Dfilter2.tcl35 execsql_test 1.1 { SELECT sum(b) FROM t1 }
72 SELECT sum(a+b) FILTER (WHERE a=NULL) FROM t1
77 HAVING sum(b) FILTER (WHERE b<20) > 34
82 SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
89 SELECT (a%5), sum(b) FILTER (WHERE b<20) AS bbb
97 sum(b) FILTER (WHERE b<20) AS bbb,
122 sum(b) FILTER (WHERE a%5=0),
123 sum(b) FILTER (WHERE a%5=1),
124 sum(b) FILTER (WHERE a%5=2),
125 sum(b) FILTER (WHERE a%5=3),
[all …]
H A Dfilter2.test37 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
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),
[all …]
H A Dwindowerr.test35 SELECT a, sum(b) OVER (
42 SELECT a, sum(b) OVER (
49 SELECT a, sum(b) OVER (
56 SELECT a, sum(b) OVER (
63 SELECT a, sum(b) OVER (
70 SELECT a, sum(b) OVER (
77 SELECT a, sum(b) OVER (
84 SELECT a, sum(b) OVER (
91 SELECT sum( sum(a) OVER () ) FROM t1;
96 SELECT sum(a) OVER () AS xyz FROM t1 ORDER BY sum(xyz);
[all …]
H A Dwindow9.test113 SELECT sum(a) OVER () FROM t2
118 SELECT a, sum(a) OVER (ORDER BY a DESC) FROM t2
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)
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()
[all …]
H A Dwindow8.tcl185 SELECT sum(b) OVER (
190 SELECT sum(b) OVER (
196 SELECT sum(b) OVER (
201 SELECT sum(b) OVER (
207 SELECT sum(b) OVER (
212 SELECT sum(b) OVER (
218 SELECT sum(b) OVER (
223 SELECT sum(b) OVER (
229 SELECT sum(b) OVER (
234 SELECT sum(b) OVER (
[all …]
H A Dwindow7.test43 SELECT a, sum(b) FROM t3 GROUP BY a ORDER BY 1;
48 SELECT a, sum(b) OVER (
65 SELECT a, sum(b) OVER (
82 SELECT a, sum(b) OVER (
100 SELECT a, sum(b) OVER (
117 SELECT a, sum(b) OVER (
135 SELECT a, sum(b) OVER (
153 SELECT a, sum(b) OVER (
170 SELECT a, sum(b) OVER (
H A Dwindow7.tcl40 SELECT a, sum(b) FROM t3 GROUP BY a ORDER BY 1;
44 SELECT a, sum(b) OVER (
50 SELECT a, sum(b) OVER (
56 SELECT a, sum(b) OVER (
62 SELECT a, sum(b) OVER (
68 SELECT a, sum(b) OVER (
74 SELECT a, sum(b) OVER (
80 SELECT a, sum(b) OVER (
85 SELECT a, sum(b) OVER (
H A Danalyze3.test126 SELECT sum(y) FROM t1 WHERE x>200 AND x<300
129 SELECT sum(y) FROM t1 WHERE x>0 AND x<1100
139 SELECT sum(y) FROM t1 WHERE x>$l AND x<$u
144 SELECT sum(y) FROM t1 WHERE x>$l AND x<$u
149 SELECT sum(y) FROM t1 WHERE x>$l AND x<$u
154 SELECT sum(y) FROM t1 WHERE x>$l AND x<$u
159 SELECT sum(y) FROM t1 WHERE x>$l AND x<$u
209 SELECT sum(y) FROM t2 WHERE x>1 AND x<2
212 SELECT sum(y) FROM t2 WHERE x>0 AND x<99
261 SELECT sum(y) FROM t3 WHERE x>200 AND x<300
[all …]
H A DorderbyA.test60 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;
[all …]
H A Dwindowerr.tcl51 SELECT sum( sum(a) OVER () ) FROM t1;
55 SELECT sum(a) OVER () AS xyz FROM t1 ORDER BY sum(xyz);
59 SELECT sum(a) OVER win FROM t1
63 SELECT sum(a) OVER win FROM t1
H A Dwindow8.test3511 SELECT sum(b) OVER (
3517 SELECT sum(b) OVER (
3523 SELECT sum(b) OVER (
3529 SELECT sum(b) OVER (
3535 SELECT sum(b) OVER (
3541 SELECT sum(b) OVER (
3547 SELECT sum(b) OVER (
3553 SELECT sum(b) OVER (
3559 SELECT sum(b) OVER (
3565 SELECT sum(b) OVER (
[all …]
H A Dwidetab1.test98 do_execsql_test 210 {SELECT sum(c62) FROM t1;} 45620
99 do_execsql_test 220 {SELECT sum(c63) FROM t1;} 45630
100 do_execsql_test 230 {SELECT sum(c64) FROM t1;} 45640
101 do_execsql_test 240 {SELECT sum(c65) FROM t1;} 45650
105 SELECT sum(c62) FROM t1;
107 SELECT sum(c62) FROM t1;
110 SELECT sum(c65) FROM t1;
112 SELECT sum(c65) FROM t1;
143 do_execsql_test 410 {SELECT sum(c08) FROM t1 WHERE c00 IN (1000,5000);} 6016
144 do_execsql_test 420 {SELECT sum(c63) FROM t1 WHERE c00 IN (1000,5000);} 6126
[all …]
H A Dwindow6.test73 SELECT sum(%x) OVER %w FROM %t1 WINDOW %w AS (ORDER BY %y)
77 SELECT sum(%alias.%x) OVER %w FROM %t1 %alias WINDOW %w AS (ORDER BY %y)
81 SELECT sum(%x) %alias FROM %t1
123 SELECT sum(x) over FROM over
127 SELECT sum(x) over over FROM over WINDOW over AS ()
131 SELECT sum(over) over over over FROM over over WINDOW over AS (ORDER BY over)
135 SELECT sum(over) over over over FROM over over WINDOW over AS (ORDER BY over);
334 SELECT a, (SELECT y FROM t3 WHERE x=a), sum(a) OVER (ORDER BY a)
342 SELECT a, sum(a) OVER win FROM t1
348 SELECT a, sum(a) OVER win FROM t1
[all …]
H A Daggnested.test133 (SELECT sum(value2==xyz) FROM t2)
143 (SELECT sum(value2==xyz) FROM t2)
166 (SELECT sum(value2==xyz) FROM t2)
172 (SELECT sum(value2<>xyz) FROM t2)
187 SELECT (SELECT sum(value2=value1) FROM t2), max(value1)
221 SELECT value1, (SELECT sum(value2=value1) FROM t2)
227 SELECT value1, (SELECT sum(value2=value1) FROM t2)
235 SELECT max(value1), (SELECT sum(value2=max(value1)) FROM t2)
242 SELECT max(value1), (SELECT sum(value2=value1) FROM t2)
256 SELECT (SELECT sum(x+(SELECT y)) FROM bb) FROM aa;
[all …]
H A Dfunc.test783 SELECT sum(x) FROM t5;
790 SELECT sum(x) FROM t5;
795 # The sum of nothing is NULL. But the sum of all NULLs is NULL.
808 SELECT sum(x), total(x) FROM t5
814 SELECT sum(x), total(x) FROM t5
820 SELECT sum(x), total(x) FROM t5
838 SELECT typeof(sum(x)) FROM t6
878 SELECT sum(x) FROM
886 SELECT sum(x) FROM
893 SELECT sum(x) FROM
[all …]
H A DwindowB.test44 SELECT sum(b) OVER win FROM t1
50 SELECT sum(b) OVER win FROM t1
77 SELECT a, sum(a) OVER win FROM t1
246 SELECT a, sum(c) OVER (
257 SELECT a, sum(c) OVER (
263 SELECT a, sum(c) OVER (
269 SELECT a, sum(c) OVER (
275 SELECT a, sum(c) OVER (
291 SELECT a, sum(c) OVER (
296 SELECT a, sum(c) OVER (
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtree7.test61 execsql_intout { SELECT sum(x1), sum(x2), sum(y1), sum(y2) FROM rt }
67 SELECT sum(x1), sum(x2), sum(y1), sum(y2) FROM rt
/sqlite-3.40.0/tool/
H A Dspaceanal.tcl255 sum(ncell) AS nentry,
256 sum((pagetype=='leaf')*ncell) AS leaf_entries,
257 sum(payload) AS payload,
259 sum(path LIKE '%+000000') AS ovfl_cnt,
261 sum(pagetype=='internal') AS int_pages,
262 sum(pagetype=='leaf') AS leaf_pages,
263 sum(pagetype=='overflow') AS ovfl_pages,
264 sum((pagetype=='internal') * unused) AS int_unused,
265 sum((pagetype=='leaf') * unused) AS leaf_unused,
267 sum(pgsize) AS compressed_size,
[all …]
/sqlite-3.40.0/ext/misc/
H A Dfossildelta.c207 unsigned sum = 0; in checksum() local
212 sum += *(unsigned*)z; in checksum()
219 sum += __builtin_bswap32(*(unsigned*)z); in checksum()
224 sum += _byteswap_ulong(*(unsigned*)z); in checksum()
235 sum += ((unsigned)z[3] + z[7] + z[11]+ z[15]); in checksum()
243 sum += z[3]; in checksum()
247 sum += (sum2 << 8) + (sum1 << 16) + (sum0 << 24); in checksum()
251 case 3: sum += (z[2] << 8); in checksum()
252 case 2: sum += (z[1] << 16); in checksum()
253 case 1: sum += (z[0] << 24); in checksum()
[all …]

123456