Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to display the return this way?
Just use decode in the order by clause.
Select A, B
from myTable
where A = 'A1' or A = 'D1' or A = 'C1' or A = 'B1'
"C Chang" <cschang_at_maxinter.net> wrote in message
news:3C1A1F19.1421_at_maxinter.net...
> I have a select script such as:
>
> Select A, B
> from myTable
> where A = 'A1'
> or A = 'D1'
> or A = 'C1'
> or A = 'B1'
order by decode(A,'A1',1 , 'D1',2, 'C1' ,3, 'B1',4,5)
;
>
> How do I let my return display as my order in where clause:
>
> A1 Bxx
> D1 BXXX
> C1 BX
> B1 Byy
>
> but not in sorted order of column A -> A1, B1, C1, D1.
>
> C Chang
Received on Fri Dec 14 2001 - 11:34:42 CST