Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Complex ORDER BY clauses
"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