Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: About ordering in SQL
Artti Jaakkola <ext-artti.jaakkola_at_nokia.com> wrote in message
news:PyGt5.10147$oL4.210919_at_news2.nokia.com...
> If I make following query:
>
> SELECT
> ID
> FROM
> SOMETABLE
> WHERE
> ID IN (1, 4, 6, 2)
>
> ID
> --
> 2
> 6
> 4
> 1
>
> Is the result always ordered like this or is there some better way to do
it?
>
> --
> - Artti -
use order by clause
> SELECT
> ID
> FROM
> SOMETABLE
> WHERE
> ID IN (1, 4, 6, 2)
> ORDER BY ID;
greet JAN
-- Disclaimer: This statement is not an official statement from, nor does it represent an official position of K.P.N. Telecom bv.Received on Thu Sep 07 2000 - 03:51:31 CDT