Re: Order by question

From: TurkBear <>
Date: Wed, 26 May 1999 20:56:57 GMT
Message-ID: <>

I'm not sure, but this should do it

column ordby noprint

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

Hope it helps...

John Greco

"Deepa Raman" <> wrote:

>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 ........
Received on Wed May 26 1999 - 22:56:57 CEST

Original text of this message