Thanks Keith! Creating a temporal table with it's own rowid solved the problem. Luis
On Sun, Jul 15, 2012 at 10:48:32AM -0600, Keith Medcalf wrote: > How about: > > drop table if exists temp.ordered; > create temporary table ordered (a number not null); > insert into ordered select a from table order by a; > select avg(a) from ordered group by rowid/100; > drop table if exists temp.ordered; > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
