good idea, I will try. thanks
At 2013-10-16 19:12:30,"Ed Soniat" wrote:
You could use a modular math to transform the data in to single value
representations of each range you intend to represent with your boundary using
a sub select.
On Wed, Oct 16, 2013 at 7:09 AM, Richard wrote:
I wa
You could use a modular math to transform the data in to single value
representations of each range you intend to represent with your boundary
using a sub select.
On Wed, Oct 16, 2013 at 7:09 AM, Richard wrote:
> I want to find the most frequent value of a column, I noticed
> histogram_numerc,
I want to find the most frequent value of a column, I noticed histogram_numerc,
but I cannot specify the bin boundary. The result is not what I want.
take an example as follows, I want something like
select gid, most_frequent(category) from mytable group by gid.
where category is a column w