Thanks Michael! It worked perfect. Phillip B
----- Original Message ----- From: "Michael McManus" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 4:09 PM Subject: RE: Is way to get a distinct count > Perhaps GROUP BY will provide the info you're looking for? > > SELECT MYSTATE, COUNT(*) AS MYCOUNT > FROM MYTABLE > GROUP BY MYSTATE > > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 20, 2003 4:27 PM > To: SQL > Subject: Is way to get a distinct count > > > Is there an easy way to find a distinct value and then show a count for each > one? > > SQL 2000 is the DB > > Phillip B. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
