On Feb 2, 2012, at 9:46 AM, Petite Abeille wrote: > > 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
to the OP... since you are using Perl (I believe, based on your earlier emails), you can get your data out and then use the most excellent List::Util (https://metacpan.org/module/List::Util). List::MoreUtils (https://metacpan.org/module/List::MoreUtils) and Scalar::Util (https://metacpan.org/module/Scalar::Util) -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users