Re: Order by question

From: TurkBear <johng_at_nospam.mm.com>
Date: Wed, 26 May 1999 20:56:57 GMT
Message-ID: <374c5ec4.1853855_at_news.dot.state.mn.us>


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

Original text of this message