How To Create a Histogram with SQL

Posted on 2012-05-04 19:41:01 by Jer

I don't do this often enough to remember the syntax and usually google gives me more complicated solutions. So this one's for me, but maybe you'll find it useful as well.

select processorCount,count(*) from serverInventory
  where status='production'
  and os_version like 'Red%'
  group by processorCount
  order by processorCount

Results will look like this.