Thank you for your explanations guys. All this makes perfect sense. I still can't find a solution to my problem though -- write a query that is guaranteed to return sorted results, in some optimal way.
Any suggestion welcome. Thank you, Gerlando Il lun 4 feb 2019, 22:24 Simon Slavin <slav...@bigfraud.org> ha scritto: > On 4 Feb 2019, at 9:14pm, James K. Lowden <jklow...@schemamania.org> > wrote: > > > As Keith said, SQLite allows ORDER BY in subqueries. The SQL standard > does not. > > True. But SQLite does not guarantee that the outer query will preserve > the inner query's ORDER BY, even if the outer query doesn't have its own > ORDER BY. So be careful. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
