Search the archives!
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
frequency analysis of a DB column
- From: carsten at uniqsys.com (Carsten Haese)
- Subject: frequency analysis of a DB column
- Date: Thu, 02 Aug 2007 08:28:46 -0400
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
- Follow-Ups:
- frequency analysis of a DB column
- From: Gabriel Genellina
- frequency analysis of a DB column
- References:
- frequency analysis of a DB column
- From: goldtech
- frequency analysis of a DB column
- From: Gabriel Genellina
- frequency analysis of a DB column
- Prev by Date: Catching SystemExit in C API code when embedding Python?
- Next by Date: Python end of file marker similar to perl's __END__
- Previous by thread: frequency analysis of a DB column
- Next by thread: frequency analysis of a DB column
- Index(es):