On Feb 2, 2012, at 4:37 PM, Bill McCormick wrote: > Does SQLite have FIRST and LAST aggregate function?
No, sadly, SQLite doesn't support any analytic functions (aka window function) such as first, last, lead, lag, rank, etc, etc... [1] To achieve the same, you will have to roll your own, which is not always a piece of cake. Oh, well... [1] http://orafaq.com/node/55 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users