On Wed, 31 Aug 2011 08:12:10 -0400, "Igor Tandetnik" <itandet...@mvps.org> wrote:
>Ivan Shmakov <i...@gray.siamics.net> wrote: >>>>>>> Tobias Vesterlund writes: >>> Is it possible to get the highest value in a "limited column" when >>> using LIMIT? >> >> Sure. >> >> SELECT max (id) FROM (SELECT id FROM t WHERE id > 0 LIMIT 10); > > This only works by accident. There's no requirement > that the subselect return rows in any particular order. > It can, in principle, choose any ten rows. You're right. I should have taken that into consideration in my posting in this thread. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users