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 whole 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-2016 The PostgreSQL Global Development Group