Re: using 'count' to show number of dupes - Mailing list pgsql-novice

On Mon, 12 Jul 2004, Andy Harrison wrote:

> I'm writing some perl to sendmail maillog reporting.  Since the logs
> are too big to some of the things I want to do, I'm just stuffing it
> to a pgsql db.  I'd like to offload as much of the work onto the db as
> much as possible.
>
> How can I use count to show rows with the same value in the column?
>
> col1   col2   col3
> foo1   bar1   baz1
> foo2   bar1   baz2
> foo3   bar2   baz3
> foo4   bar3   baz4
> foo5   bar1   baz5
> foo6   bar2   baz6
>
>
> So, what would get pg to show me that col2 has 3 'bar1' values, 2
> 'bar2' values and 1 'bar1' value.

Something like:
select col2, count(*) from table group by col2;