Re: count(distinct col)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chau, Artemis" <artemis(dot)chau(at)intel(dot)com>
Cc: "'pgsql-novice(at)hub(dot)org'" <pgsql-novice(at)hub(dot)org>
Subject: Re: count(distinct col)
Date: 2000-08-01 21:59:40
Message-ID: 28401.965167180@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Chau, Artemis" <artemis(dot)chau(at)intel(dot)com> writes:
> What is the equivalent of
> "select count(distinct col) from tbl" in PGSQL?

That's easy, "select count(distinct col) from tbl".

(If you're running 7.0 that is. If not, why not?)

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chau, Artemis 2000-08-01 22:07:36 RE: count(distinct col)
Previous Message Chau, Artemis 2000-08-01 21:46:51 count(distinct col)