frequency analysis of a DB column

Gabriel Genellina gagsl-py2 at yahoo.com.ar
Thu Aug 2 19:49:57 EDT 2007


En Thu, 02 Aug 2007 09:28:46 -0300, Carsten Haese <carsten at uniqsys.com>  
escribió:

> On Thu, 2007-08-02 at 00:38 -0300, Gabriel Genellina wrote:
>>
>> 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.

To waste a few more microcalories moving my fingers typing nonsense?

-- 
Gabriel Genellina




More information about the Python-list mailing list