1 2 Previous Next 16 Replies Latest reply: Feb 12, 2013 9:45 AM by BluShadow Go to original post RSS
      • 15. Re: count function
        pawii
        so 1,0 are part of decode or sum??
        and if they belongs to decode then either 1 or 0 will be return at a time??
        • 16. Re: count function
          BluShadow
          987018 wrote:
          so 1,0 are part of decode or sum??
          What part of breaking down the brackets to the individual statements are you having difficulty with?
          and if they belongs to decode then either 1 or 0 will be return at a time??
          Yes, a 1 or 0 for each row depending on the condition. The SUM will then sum up the 1's and 0's to give you a count of those rows that meet the condition.
          1 2 Previous Next