npearson99 wrote: > 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
As Simon mentioned, SQLite doesn't support anything remotely similar to this syntax. My best guess at what you are trying to do here is something like this: select months, minutes, (select sum(salary) from tblSalaryData d2 where d2.months = d1.months and d2.minutes <= d1.minutes) from tblSalaryData d1; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
