Re: DECODE

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Fri, 16 Apr 2010 15:33:33 -0700 (PDT)
Message-ID: <bf77737d-ce49-4021-befa-122171ad8294_at_v20g2000yqv.googlegroups.com>



On Apr 16, 6:03 pm, The Magnet <a..._at_unsu.com> wrote:

snip

> Can you nest DECODE with different field criteria?  Here is our
> DECODE:
>
> DECODE(SUM(DECODE(subproduct_id, 238, 1, 0)) OVER (PARTITION BY
> customer_id),0,'N','Y') ultimate_trader
>
> Now, with that, if the result is Y, meaning that they DO have this 238
> product, I want to see if they have a status = 'Active'.  So, is there
> a way to implement yet another level, testing the status = 'Active' if
> the result of the above statement is 'Y'?

Did you try testing what you wanted to do?

Have you ever heard of inline views? Received on Fri Apr 16 2010 - 17:33:33 CDT

Original text of this message