On 29 Nov 2009, at 5:08am, npearson99 wrote: > select sum(salary) over > (partition by months order by minutes rows between unbounded preceding and > current row) > from tblSalaryData > > I get an error by partition. I know this doesn't give me the moving > average, I'm just trying to get the "over" statement part to register.
That's Oracle, not standard SQL. It will work only in Oracle. SQLite may be able to do the same thing but I don't understand enough about what you wrote to even make a guess how to do it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
