[thelist] counting frequency of distinct values in MSSQL

[Joshua Olson]

----- 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