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 SQL
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 selec
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 ag
3 matches
Mail list logo