Re: Histogram Procedure/Function
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Fri, 10 Mar 2006 11:48:12 -0800
Ethan,
not sure if it will server your purpose, but check out the ntile() analytic
function.
Quoting Ethan Post <post.ethan@xxxxxxxxx>:
> I am looking for the easiest way to take a select and transform into some
> sort of histogram...
>
> select numeric_value from table_name;
>
> should come back as
>
> range total
> 1-10 30
> 11-20 100
> ...
>
--
regards
Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
