[dba-SQLServer] Counts of value ranges

jwcolby jwcolby at colbyconsulting.com
Thu Apr 24 08:43:49 CDT 2008


Guys,

Is there a way in SQL to get counts of records in value ranges:

$2,000,000+
$1 - $1.99M
$750K - $999K
$500K - $749K
$400K - $499K
$300K - $399K
$200K - $299K
$100K - $199K
<$100K
-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list