help by order by

From: (wrong string) äusler <luciver_at_teleweb.at>
Date: Sat, 24 Feb 2001 17:45:41 GMT
Message-ID: <9rSl6.84185$GC5.3059984_at_news.chello.at>


Hi!

I have a select like this:

[Quoted] [Quoted] 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 - 18:45:41 CET

Original text of this message