Re: In line queries......

From: Robert Klemme <bob.news_at_gmx.net>
Date: Thu, 9 Mar 2006 17:00:03 +0100
Message-ID: <47b1o4Feqs52U1@individual.net>

Miggins wrote:
> Have to add that i have simplified the selection criteria for this
> post....there are other conditions to apply to the SUB_START and
> SUB_END dates to determine whether a subscription is active or
> not....just didnt want to clutter the query
>
> Also running on 9.2.0.4

# untested
select case subs_end when NULL then 'active' else 'cancelled' end "type", count(*)
from ...
group by case subs_end when NULL then 'active' else 'cancelled' end

robert Received on Thu Mar 09 2006 - 10:00:03 CST