Re: default select order

From: ddf <oratune_at_msn.com>
Date: Thu, 8 Jan 2009 07:34:53 -0800 (PST)
Message-ID: <a181a1a5-d323-46dd-82f1-75c3413d9229_at_w1g2000prm.googlegroups.com>



On Jan 7, 7:06 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Jan 7, 3:27 pm, ddf <orat..._at_msn.com> wrote:
>
> snip
>
> > So, John, your guess was a bit better than my first one.  Why didn't
> > you share your work with the rest of us?
>
> It is not exactly a secret ... use ORDER BY to specify how you want
> the rows returned.
>

Which I stated early on in this thread:

> That is, we have two select-statements that should return rows in the same
> order but there is no order by -clause.

Without an Order By clause then there is no issue as 'default' ordering doesn't exist.

David Fitzjarrell Received on Thu Jan 08 2009 - 09:34:53 CST

Original text of this message