Re: count different values in column - Mailing list pgsql-sql

On Fri, 19 Apr 2002, Albrecht Berger wrote:

> Now I want to count the different values in the column.
>
> Resulttable :
>    a
> ------
> 10
> 12
> 12
> 12
> 14
> 14
> 15
>
> I need the value which is repeated most in the resulttable (in this example
> 12 ) !

SELECT a, count(a) FROM resulttable GROUP BY a ORDER BY 2 DESC
-- 
Tod McQuillin