Re: SQL Order

On Mon, 16 Sep 2002 17:23:16 GMT, "Lucas" <Lucas_44_at_hotmail.com> wrote:

>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
>
>

We're talking about relational databases and about sets here. Sets are by definition unordered.
The solution would be to
select decode(empcode,810,1,974,2,603,2,648,3,null) sortorder, * from emp
where empcode in (810,974,603,648)
order by sortorder

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Sep 16 2002 - 13:20:48 CDT