Home -> Usenet -> c.d.o.server -> Re: CASE statement in WHERE Clause - Weird one

Re: CASE statement in WHERE Clause - Weird one

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Thu, 22 May 2014 00:21:50 -0700 (PDT)
Message-ID: <e14e00a3-aef7-4aac-b64b-74d7a582cf91_at_googlegroups.com> 






Hi,


what about this ?

SELECT ROUND(AVG(pct_total),2)               
  INTO v_average                            
  FROM pfp_to_buyer_agg                     


 WHERE registration_period >= '01-OCT-2012'
   AND (   ( v_period <> 1 and period = v_period)

        or ( v_period  = 1 and period in (0,1)
       )   ;                 





But as Geoff said, it's clearer to do the case outside the selects



regards


Kay
Received on Thu May 22 2014 - 09:21:50 CEST












Original text of this message