Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    18

    Unanswered: Simple Query Question

    Hi Friends,
    I've a simple question.I am using the SUM function in my query with the group by clause.I just need to get the total elements that were used to calculate the sum.If i use the COUNT on the same column,will it give me the answer.Please help me.

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    Not necessarily. SUM will not include nulls, COUNT will include the rows with the nulls.

    James Campbell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •