Re: help by order by

Apparently you don't want the desc which an acronym for descending Remove it and see whether the result suits you. If you don't have access to manuals they are online at http://technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA

On Sat, 24 Feb 2001 17:45:41 GMT, "Peter Häusler" <luciver_at_teleweb.at> wrote:

>Hi!
>
>I have a select like this:
>
>SELECT hra_id||hra_name from hra_akten order by 1 desc;
>
>the output :
>
>KOR/119
>KOR/220
>A/1
>A/2
>
>but i need a ouput like
>
>A/220
>A/119
>..
>A/2
>A/1
>KOR/220
>KOR/119
>
>and so on.
>Has anyone a help for a newbe??
>thanks a lot for your time
>
>PS: Sorry for my bad english but i am from austria.
>
Received on Sat Feb 24 2001 - 22:12:08 CET