SQLite Forum

Show duplicate rows sorted
There is no sorting which should be relied upon \[a\] without using ORDER BY or subjecting query results to an external processing step. 

\[a. There is plenty of ordering that happens without ORDER BY, as a consequence of insertion order, query optimization, and probably many other influences, but it cannot be relied upon outside of the "Try it and see if, By Golly, it works!" school of Programming for Bumblers. \]