Re: In line queries......

From: Robert Klemme <bob.news_at_gmx.net>
Date: Fri, 10 Mar 2006 10:26:22 +0100
Message-ID: <47cv1uFel0d9U1@individual.net>

Michel Cadot wrote:

> "Robert Klemme" <bob.news_at_gmx.net> a écrit dans le message de news:
> 47b1o4Feqs52U1_at_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
>>

>
> When answer is trivial, this is surely a homework question.
> Take care to only give an indication and not a solution.

I usually do but I didn't view this as HW assignment.

> You know the story about the fish...

:-)

Thanks for the reminder anyway!

    robert Received on Fri Mar 10 2006 - 03:26:22 CST