On 3/9/18, Hegde, Deepakakumar (D.) <deep...@allgosystems.com> wrote: > > So for us expected output is:
If your query does not have an ORDER BY clause, then SQLite (and every other SQL database engine) is free to return the result rows in any order it wants. At this point in history, SQLite happens, by chance, to return the rows in rowid order for your particular query. But that might change with the next release. Or it might change with shifts in the jet stream. You never know. The point is that you must never depend on a particular row order from a SELECT statement that lacks an ORDER BY clause. If you need to output rows in a particular order, then please devise an ORDER BY clause that expresses that ordering. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
