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: (view raw or flat)
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-2015 The PostgreSQL Global Development Group