DECODE
From: The Magnet <art_at_unsu.com>
Date: Fri, 16 Apr 2010 15:03:20 -0700 (PDT)
Message-ID: <e5147c96-9572-47d9-9480-ef91a25c8c32_at_z3g2000yqz.googlegroups.com>
Date: Fri, 16 Apr 2010 15:03:20 -0700 (PDT)
Message-ID: <e5147c96-9572-47d9-9480-ef91a25c8c32_at_z3g2000yqz.googlegroups.com>
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'? Received on Fri Apr 16 2010 - 17:03:20 CDT