On 9/19/2012 12:51 PM,
joe.fis...@tanguaylab.com wrote:
Too bad SQLite doesn't yet support SQL Window Functions.
Are there any SQLite Extension Libraries that support "SQL:2003 type
Window Functions"?
I specifically need LEAD and LAG to calculate an event integer timestamp
delta between consecutive rows.
I've played with some self-join code but that's proving to be complicated.
The easiest approach is to maintain the window in your application code,
as you iterate over a simple SELECT statement.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
