I'm trying to calculate a moving average in sqlite through sqliteman. I'm just trying to get some of the analytic functions to work, but I keep getting a syntax error. I got this from a sql wiki page, so I hope something like this will work.
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. Any ideas? Thanks! -- View this message in context: http://old.nabble.com/Moving-Average--tp26559410p26559410.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
