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 Get the mailserver that powers this list at http://www.coolfusion.com
