Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Record order in SELECT .. IN ( , , , ) queries

Re: Record order in SELECT .. IN ( , , , ) queries

From: Steve Bell <stephenb_at_sympatico.ca>
Date: Mon, 26 Jan 2004 07:31:13 -0500
Message-ID: <ph8Rb.21259$Kg6.171521@news20.bellglobal.com>


Hi Kurta,

The best way to guarantee the order of your results is to use the ORDER BY clause at the end of your SELECT.

In your case, add the clause ORDER BY USR_ID (for ascending order) or ORDER BY USR_ID DESC (descending order).

I hope this helps,

Steve

"Kurta" <submit_at_galleus.com> wrote in message news:efcb1994.0401260151.7216f23c_at_posting.google.com...
> When I start a SELECT IN query like this:
>
> SELECT USR_ID, USR_NAME FROM T_USR WHERE USR_ID IN (4, 2, 5, 1, 3);
>
> Is there a guaranteed result record order? I tried these queries and
> (using Oracle 9i) it always returned the results in reverse order (not
> the phisical order):
>
> USR_ID USR_NAME
> ----------------------------------------------
> 3 a
> 1 a
> 5 a
> 2 a
> 4 a
>
> Can I assume that this order is always the same? Is there a technical
> documentation about this?
>
> Thanks,
>
> Kurta
Received on Mon Jan 26 2004 - 06:31:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US