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
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