Re: Q: SQL output order by keys possible?

From: Bill Wine <biwine_at_vassar.edu>
Date: 1996/10/08
Message-ID: <53eich$prr_at_vassun.vassar.edu>#1/1


You can order by a decode, e.g.

order by decode(substr(DEPT,1,2),'PR',' ',DEPT)

Bill

>f91-gal_at_nada.kth.se (Göran Alterland) wrote:
>I've run into this snag. Having a table, is there any way to
>sort the output in anything but ascending/descending order?
>
Received on Tue Oct 08 1996 - 00:00:00 CEST

Original text of this message