Re: using 'count' to show number of dupes

From: Andy Harrison <aharrison(at)gmail(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: using 'count' to show number of dupes
Date: 2004-07-12 18:02:14
Message-ID: a22ff29404071211026105527d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, 12 Jul 2004 10:39:00 -0700 (PDT), Stephan Szabo
<sszabo(at)megazone(dot)bigpanda(dot)com> wrote:
>
> Something like:
> select col2, count(*) from table group by col2;
>

Great, thanx. That got me on the right road. Fast too. Several mere
seconds for 1.25M rows.

--
Andy Harrison

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ralf Hasemann 2004-07-12 21:35:03 plpgsql functing does not use index....
Previous Message Loftis, Charles E 2004-07-12 17:50:39 Re: using 'count' to show number of dupes