SQLite Forum

order of INSERT affects the output
Login
Don't do processing that requires a specific visitation order or output order without making sure that the required order is actually guaranteed. Which usually means adding an ORDER BY clause to uniquely determine said order.