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

Re: Counting Distinct Records

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Counting Distinct Records
Date: 2004-11-16 22:34:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
On Tue, 16 Nov 2004, Thomas F.O'Connell wrote:

> Is there another way to accomplish what the former is doing, then?

The only thing I can think of is a subselect in from that uses distinct.
 select count(*) from (select distinct ...) foo

That also theoretically allows you to use select distinct * inside the

In response to


pgsql-sql by date

Next:From: Thomas F.O'ConnellDate: 2004-11-16 23:02:56
Subject: Re: Counting Distinct Records
Previous:From: Andrew SullivanDate: 2004-11-16 22:09:37
Subject: Re: Move table between schemas

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