On 22 Jul 2012, at 17:06, Keith Medcalf wrote:
> (select name, max(validfrom) as mvf from aliases where validFrom <= (select
> strftime('%s', 'now')) group by name)I don't think that solves the problem because each time the group by query is executed, your subquery will be executed again. Thanks, Kev _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
