[thelist] counting frequency of distinct values in MSSQL
Joshua Olson
joshua at waetech.com
Sat Sep 13 14:15:17 CDT 2003
----- Original Message -----
From: "Joel D Canfield" <joel at spinhead.com>
Sent: Saturday, September 13, 2003 3:10 PM
> I've toyed with COUNT and COUNT DISTINCT, but I can't figure out how to
> count the frequency of each unique value.
spin,
How about COUNT(DISTINCT blah)
Note, that may not count nulls.
HTH,
<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com
706.210.0168
More information about the thelist
mailing list