Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Complex ORDER BY clauses

Re: Complex ORDER BY clauses

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Thu, 13 Nov 2003 12:23:54 -0600
Message-ID: <tvi7rv8e60ns3cguu17e08l26klpqg7qv8@4ax.com>


"Dave Rudolf" <dave_the_funkatron_at_hotmail.com> wrote:

>Hi all,
>
>Suppose that I have a column in a table, and I want to sort it so that
>certain values come first, but the sorting is not lexographical. For
>example, if I have a rediculously simple table, that has only one column,
>like so:
>
>'A'
>'B'
>'C'
>'D'
>'E'
>
>I want to sort the table so that Bs and Es come first, like so:
>
>'B'
>'E'
>'A'
>'C'
>'D'
>
>Is there some way to do such a thing?
>
>
>
>Dave
>

AFAIK, No, unless some other field has the sort order key... Received on Thu Nov 13 2003 - 12:23:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US