Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stewart Campbell Count Distinct RE: Count Distinct

  • January 31, 2011 at 9:26 am

    #1280482

    twalpole (1/31/2011)

    If requesting parts ordered more than once, need to query for diff > 0

    Nice catch. The difference is between a count(DISTINCT) and and a straight count. With all unique parts, the count(distinct) would equal the count() and the difference would be zero. With a repeat order for a part, the count(DISTINCT) would be less than the straight-up count().