On 1/11/17, Bart Smissaert <bart.smissa...@gmail.com> wrote:
>
> The result is that the output is descending on DOB.
> I expected and preferred if the output was ascending on rowid.
If you omit the ORDER BY clause, then the SQL database engine (*any*
engine, not just SQLite) is free to return the rows in whatever random
order it chooses. And it does not need to explain itself when it
does. :-)
If you expect and/or prefer the output to be in order of ascending
rowid, then add
ORDER BY rowid ASC
to the end of the query.
--
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
