Re: Q: SQL output order by keys possible?

From: Michael Ho <infoage_at_hk.super.net>
Date: 1996/10/09
Message-ID: <325C50E3.6B39_at_hk.super.net>#1/1


G=F6ran Alterland wrote:
> =
 

> select EMP,SALAR from ALL_EMPS
> where SALAR <=3D 10000
> order by DEPT where DEPT like 'PR' first

Try this :

select emp,salar from all_emps
  where salar <=3D10000
  order by decode(dept, 'PR', 'A', dept)

Enjoy,
Michael Received on Wed Oct 09 1996 - 00:00:00 CEST

Original text of this message