Re: Order by question

I'm not sure, but this should do it

Select status,decode(status,'I',1,'F',2,'U',3) ordby from table
order by ordby;

Hope it helps...

John Greco

"Deepa Raman" <DeepaR_at_aeimusic.com> wrote:

>Hi,
>
>I have a table which has a column called "status"
>There are three values status can have 'I', 'F', U'
>
>When I write the query to select from this table I want to get all the 'I' [Quoted] [Quoted]
>first, then the 'F' then the 'U' records.......
>
>How would I say that in an order by clause ........
>
>Thanks,
>Deepa.
>Deepar_at_aeimusic.com
>
Received on Wed May 26 1999 - 22:56:57 CEST