Hi!
Maybe I do not understand something, but does it really have to work this
way?
DROP TABLE IF EXISTS t;
CREATE TABLE t (v1,v2,v3,v4);
INSERT INTO t (v1,v2,v3,v4) VALUES
(1,1,10000,0),(1,1,0,1),(2,1,0,10),(3,1,0,100),(3,1,0,1000);
SELECT
v1,v2,sum(v3+v4) OVER (PARTITION BY v2 ORDER BY v1) as val
FROM t
v1 v2 val
1 1 10001
1 1 10001
2 1 10011
3 1 11111
3 1 11111
SELECT
v1,v2,sum(v3+v4) OVER (PARTITION BY v2 ORDER BY v1) as val
FROM t
GROUP BY v1,v2;
v1 v2 val
1 1 10000
2 1 10010
3 1 10110
Yes, I know that v1 is duplicated, but whether the result should disappear
10011?
---
Anton Azanov
--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
