select yourValue, count(1) from yourTable group by yourValue order by count(1)
>From: "Phillip B" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: Is way to get a distinct count >Date: Thu, 20 Feb 2003 15:26:45 -0600 > >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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
