Links

Lists

Latest Updates

Ruby On Rails List
Python list
Advanced Java
The JavaScript List
Apache Users
Full Disclosure
Linux Security

Search the archives!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

frequency analysis of a DB column


  • From: gagsl-py2 at yahoo.com.ar (Gabriel Genellina)
  • Subject: frequency analysis of a DB column
  • Date: Thu, 02 Aug 2007 20:49:57 -0300

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