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

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 (view raw, whole thread or download thread mbox)
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

pgsql-novice by date

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

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