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

Home -> Community -> Usenet -> c.d.o.server -> SQL Order

SQL Order

From: Lucas <Lucas_44_at_hotmail.com>
Date: Mon, 16 Sep 2002 17:23:16 GMT
Message-ID: <8soh9.3868$pa1.437731@news0.telusplanet.net>


Hi all,

I want my query result to be in the same order as my codes that I set:

Ex:

select * from
Emp
where empcode in (810,974,603,648)

The result is not at all in this order? Any suggestions on why? Or is there a better way of doing this?

Lucas Received on Mon Sep 16 2002 - 12:23:16 CDT

Original text of this message

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