Djelf wrote: > 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 > 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?
Looks correct. The Postgres manual explains it this way: > If the query contains any window functions, these functions are > evaluated after any grouping, aggregation, and HAVING filtering is > performed. That is, if the query uses any aggregates, GROUP BY, or > HAVING, then the rows seen by the window functions are the group rows > instead of the original table rows from FROM/WHERE. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
