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 -- http://mail.python.org/mailman/listinfo/python-list