Ben Nadel at the New York ColdFusion User Group (Jun. 2010) with:
( photo link )
Posted on Mar 23, 2007 at 5:42 PM
Select distinct can be used instead of count distinct ie. SELECT DISTINCT -- Columns B.SOCREX, COUNT(b.socrex) -- Tables FROM "WMSPBSF00"/"CHCART00... read more »
Ben Nadel © 2014.
All content is the property of Ben Nadel and BenNadel.com