SQL to create histograms

Posted by coldclimate on Monday May 24, 2010 @03:24AM
from the wishli.st dept.

http://wishli.st/blog/creating-histogram-data-using-sql/

There's nothing really complicated about it, but I didn't find a good example online anywhere, so when I figured it out, it was time to share it

( 3 comments | 6 points | on HN )

Re:SQL to create histograms by tom_b on Monday May 24, 2010 @08:08AM (#1374418)

A little flaky perhaps, but if you're gonna love sql :-)

select distinct cnt, count(cnt) over (partition by cnt) from (

select 'a' usr,1 cnt from dual union select 'b' usr,1 cnt from dual union select 'c' usr,2 cnt from dual union select 'd' usr,3 cnt from dual union select 'e' usr,3 cnt from dual )

[ Parent | on HN ]

Re:SQL to create histograms by chrisbolt on Monday May 24, 2010 @03:52AM (#1374080)

Something tells me that query would probably run faster if written as a join, especially in MySQL.

Also, what's the point of a section of the same content in the article being repeated in a larger font to the left?

[ Parent | on HN ]

Re:SQL to create histograms by coldclimate on Monday May 24, 2010 @04:55AM (#1374151)

Hmm, you're right it would probably run a bit faster as a JOIN, I just default to using subqueries by nature.

Re:Theme with massive paragraph - it was based on a magazine wordpress theme and we're yet to edit it down.

[ Parent | on HN ]