Re: Query sorting without Order by

Hallo Jim

Thank you for your advice.
Well, actually I already have belief like yours. But my friend (Project leader) insist that in MS SQL that thing can be done (manipulating index), and the result always true (already sorted).
And he said this process will be quicker than if we use order by . I can not disprove/prove because i don't have ms sql. any clue ?

Thank you for your attention.

Jim Kennedy <kennedy-family_at_home.com> wrote in message news:2aqf6.376288$U46.11115697_at_news1.sttls1.wa.home.com...
> Without order by (in any database) the results are unspecified as to what
> order they come back in. It maybe in some cases that the rows come back
 in
> the order you desire, however, that may not always be true. Why don't you
> want to specify what order you want the data in?
> Jim
>
> "Putrasto" <putasto_at_mmedia-i.com> wrote in message
> news:qpCf6.13434$K6.105746_at_news...
> > Hallo all...
> >
> > I want to make sql query (in stored procedure) to select rows,
> > and i want the selected rows automatically ordered (ascending or
> > descending),
> > without keyword 'order by' in the query .
> > Is that possible in oracle?
> > my friends told me that he ever done that in MS SQL using index
> > in its table (design).
> >
> > Thank in advance.
> >
> >
>
>
Received on Mon Feb 05 2001 - 14:05:01 CST