frequency analysis of a DB column

[Carsten Haese]

On Thu, 2007-08-02 at 00:38 -0300, Gabriel Genellina wrote:
> I'd start with:
> 
> select column, count(column), min(column), max(column)
>  from table
> group by column
> order by count(column) desc

What's the point of including min(column) and max(column)? They're
always going to be equal to column.

-- 
Carsten Haese
http://informixdb.sourceforge.net