DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Group By "logarithmic" Count In SQL
select dist, count(dist)
from (select round(pow(10,ceil(log(10,distance+0.0001))))
as dist from cust\_with\_dist) as foo
group by dist
This gives
dist | count
------+-------
0 | 142
10 | 235
100 | 111
1000 | 7
