Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group