Re: Qurey question

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Fri, 9 Nov 2001 15:41:46 -0500
Message-ID: <gdXG7.26227$9_6.3880406@news20.bellglobal.com>

Hi Sybrand,

I agree it'll be a nightmare if his ordering problem gets any more complicated, but your post was a nice solution for the problem...thanks..I learned from that one!

Steve

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tsp3nhporr1o1f_at_corp.supernews.com...
>
> "Jack Simmions" <laclac01_at_yahoo.com> wrote in message
> news:3bcc7e9d_2_at_corp-news.newsgroups.com...
> > in the order of 10, 30, 20 I wish them to appear.
> >
> > "Alexei VORONOV" <alexei_voronov_at_yahoo.com> wrote in message
> > news:9qhrov$aa$1_at_wanadoo.fr...
> > >
> > > "Jack Simmions" <laclac01_at_yahoo.com> a écrit dans le message news:
> > > 3bcc6406_3_at_corp-news.newsgroups.com...
> > > > In a query if I want to order my departments by a department number
in
> > > order
> > > > of 10, 30, 20 how would I go about attempting this? Can this be done
> > with
> > > ^^^^^^^^^^ In what order?
> > >
> > >
> >
> >
>
> order by decode(10,1,30,2,20,3)
>
> If the number of values becomes larger this is going to be a nightmare
>
> Hth,
>
> Sybrand Bakker
> Senior Oracle DBA
>
>
>
Received on Fri Nov 09 2001 - 14:41:46 CST