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. Joe Fisher Oregon State University _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users