You are not guaranteed any particular order unless you use ORDER BY, even between two runs of the same SQL statement.
Roland Romvary wrote: > Hi! > > Can I take it for sure that the order of the rows returned by 2 queries are > the same? > The only difference between the queries is that the selected columns of the > first query are subset of the second. > > Ex: > select name, age from table1 where age > 18; > > select name, age, addr from table1 where age > 18; > > (queries may include joins and unions and are generated based on a complex > set of switches) > > Thank you for your answer! > Bye > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users