Re: [sqlite] Return row order

On Mon, Feb 25, 2008 at 7:13 AM, Roland Romvary <[EMAIL PROTECTED]> wrote: > 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. No, the

Re: [sqlite] Return row order

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

[sqlite] Return row order

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