Re: help by order by
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 5 Mar 2001 23:49:02 +0100
Message-ID: <ta85qvp2ekt83f_at_beta-news.demon.nl>
Date: Mon, 5 Mar 2001 23:49:02 +0100
Message-ID: <ta85qvp2ekt83f_at_beta-news.demon.nl>
"Peter Häusler" <luciver_at_teleweb.at> wrote in message
news:9rSl6.84185$GC5.3059984_at_news.chello.at...
> 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.
>
>
Remove desc which is an acronym for descending.
Hth,
Sybrand Bakker, Oracle DBA Received on Mon Mar 05 2001 - 23:49:02 CET