Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: SUM of COUNT

    Hi Jeff,

    I have lot of WHEN condition in the query, I have provided two conditions only in my example.

    Putting WHERE (prd_cd='1' or prd_cd='2' or pr_cd='3' ) will not be correct?

    Thanks!!

  • RE: SUM of COUNT

    Hi, can anyone help here?

    Thanks!!

  • RE: SUM of COUNT

    Laurie, I am getting below error. Also I am looking for SUM of COUNT not SUM of fields.

    104: SQL0104N An unexpected token "SUM" was found following ""....

Viewing 3 posts - 1 through 3 (of 3 total)