Thread: count(distinct col)
What is the equivalent of "select count(distinct col) from tbl" in PGSQL?
"Chau, Artemis" <artemis.chau@intel.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
Runing 6.5.2, get Syntax error for the statement. -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, August 01, 2000 5:00 PM To: Chau, Artemis Cc: 'pgsql-novice@hub.org' Subject: Re: [NOVICE] count(distinct col) "Chau, Artemis" <artemis.chau@intel.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